Skip site navigation (1) Skip section navigation (2)

Re: Get postgresql workin in french...

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: Guy Doune <cesium5500(at)yahoo(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Get postgresql workin in french...
Date: 2005-08-31 08:10:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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 FuchsDate: 2005-08-31 08:32:19
Subject: Re: Get postgresql workin in french...
Previous:From: Matthew PeterDate: 2005-08-31 07:50:20
Subject: Re: optimum settings for dedicated box

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group