| From: | Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr> |
|---|---|
| To: | Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>, Francisco Reyes <lists(at)natserv(dot)com> |
| Cc: | pgsql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: spanish characters in postgresql |
| Date: | 2002-03-12 06:55:33 |
| Message-ID: | 200203120655.g2C6tXN4012481@www1.translationforge |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank_Lupo Frank_Lupo | 2002-03-12 07:15:10 | if possible execute a function a start/end connection session ? |
| Previous Message | Francisco Reyes | 2002-03-12 05:46:46 | Re: spanish characters in postgresql |