Re: upper() with LATIN1 problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lic(dot) Guillermo González" <g(dot)gonzalez(at)cybira(dot)biz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: upper() with LATIN1 problem
Date: 2005-04-13 16:01:21
Message-ID: 7797.1113408081@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

=?ISO-8859-1?Q?=22Lic=2E_Guillermo_Gonz=E1lez=22?= <g(dot)gonzalez(at)cybira(dot)biz> writes:
> If I use LATIN1 (spanish) what value is the best option for this
> variable/parameter?

Unfortunately locale names are not all that well standardized.
"locale -a" should show you all the names available on your platform.
You probably want some variant of "es_ES", the tricky part is figuring
out which one uses LATIN1 as opposed to any other encoding.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2005-04-13 16:14:22 Help installing 8.0.2 rpms on RH 3.0
Previous Message Lim, Terrin 2005-04-13 15:20:40 Destroying all exisitng tables in database