On Tue, Aug 30, 2005 at 09:39:40AM -0400,
Guy Doune <cesium5500(at)yahoo(dot)ca> wrote
a message of 28 lines which said:
> for getting postgresql accepting my entry with accent an all the
> what the french poeple put over there caracter while they write...
I use PostgreSQL with French data (names, addresses, etc).
> I gonna continu to search why it doesn't work...
You should give details such as commands attempted and error messages
> I would know how to set the encoding (unicode, ASCII, etc.)
I use Unicode (actually, "UTF-8" would have been a better name)
because the database stores names in other languages, that you cannot
express with Latin-1.
I use the type TEXT and I can store and retrieve UTF-8 names (mostly
via Python programs) and basic operators like LIKE work fine (for
instance, _ matches one Unicode character, not one byte, which is
the right thing).
In response to
pgsql-general by date
|Next:||From: Harald Fuchs||Date: 2005-08-31 08:32:19|
|Subject: Re: Get postgresql workin in french...|
|Previous:||From: Matthew Peter||Date: 2005-08-31 07:50:20|
|Subject: Re: optimum settings for dedicated box|