|
Home > Archive > PostgreSQL Discussion > August 2005 > Get postgresql workin in french...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Get postgresql workin in french...
|
|
| Guy Doune 2005-08-30, 8:24 pm |
| Hi,
I would know how to set the encoding (unicode, ASCII,
etc.) for getting postgresql accepting my entry with
accent an all the what the french poeple put over
there caracter while they write...
Well thanks in advance.
Just leave me a links our try to explain it.
I gonna continu to search why it doesn't work...
Cesium
____________________
____________________
__________________
Find your next car at http://autos.yahoo.ca
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
| |
| Stephane Bortzmeyer 2005-08-31, 3:24 am |
| On Tue, Aug 30, 2005 at 09:39:40AM -0400,
Guy Doune <cesium5500@yahoo.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
obtained.
> 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).
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
| |
| Harald Fuchs 2005-08-31, 11:23 am |
| In article <20050830133940.84685.qmail@web54008.mail.yahoo.com>,
Guy Doune <cesium5500@yahoo.ca> writes:
> Hi,
> I would know how to set the encoding (unicode, ASCII,
> etc.) for getting postgresql accepting my entry with
> accent an all the what the french poeple put over
> there caracter while they write...
French is covered both by Latin9 and Unicode. Don't use Latin1 - it's
missing the French OE ligature.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
|
|
|
|
|