Re: spanish characters in postgresql

On Tue, 2002-03-12 at 07:55, Jean-Michel POURE wrote:
> Le Mardi 12 Mars 2002 00:28, Manuel Sugawara a écrit :
> > initdb(1) with Latin1 encoding.
>
> Do you need euro support? Latin1 does not suppor the euro symbol (and
> transforms it into 'euro'). It can be a problem, here, in Europe.
>
> Latin9 is recommended for euro support and replaces Latin1  (Latin9 =
> ISO_8859_15 = Latin1 + euro). Therefore, you should always create a database
> with encoding= 'Latin9'.
>
> If you really need Latin1 client side for some appplication, you can always
> recode characters on the fly using : SET CLIENT_ENCODING = 'Latin1';

aaaaaarrrrrgggghhhhh!!!!!! Wish I had known that sooner

Merci Jean-Mi


Tony Grant
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html