Re: French Characters

From: Jon Earle <je_pgsql(at)kronos(dot)honk(dot)org>
To: Ernest E Vogelsinger <ernest(at)vogelsinger(dot)at>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: French Characters
Date: 2003-05-26 18:27:16
Message-ID: Pine.LNX.4.55.0305261421310.8198@kronos.honk.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 26 May 2003, Ernest E Vogelsinger wrote:

> You need to set the client to a matching character set if you're using
> UNICODE as database character set.
>
> E.g., using psql, upon connecting to a UNICODE database, psql automatically
> uses the unicode caracter set - there's no 'é' character in UNICODE, as
> this will be encoded using 2 bytes.

There's something I'm not understanding. Unicode does contain the
accented e character - it's character 0x00e9. I thought the whole point
of unicode was to avoid having to specify character sets and have the
whole thing "just work" but it would seem that's not the case. If a app
is created and an installable ISO containing that app is built and
downloaded by users in China, Zimbabwe, Egypt, Brazil and France, each
will require one of these client encodings be selected. How then, can the
app 'know' where it is and select the correct encoding?

Cheers!
Jon

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2003-05-26 18:36:04 Re: latin1 -> unicode
Previous Message Fontenot, Paul 2003-05-26 18:14:33