Re: spanish characters in postgresql

From: tony <tony(at)animaproductions(dot)com>
To: jm(dot)poure(at)freesurf(dot)fr
Cc: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>, Francisco Reyes <lists(at)natserv(dot)com>, pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: spanish characters in postgresql
Date: 2002-03-12 08:45:45
Message-ID: 1015922746.1660.10.camel@vaio
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Snow 2002-03-12 08:58:47 Re: Can a field be a primary key as well as a foreign key?
Previous Message tony 2002-03-12 08:44:01 Re: Postgres on Apple hardware?