Re: spanish characters in postgresql

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';

Cheers, Jean-Michel POURE