I don't believe that locale is supported in postgresql.
for a list of supported character sets.
Double check and make sure that postgres didn't use the default encoding
of Unicode instead. There is a known bug in 7.4x with Upper/Lower
conversion in Unicode and perhaps that is affecting your encoding as
On Thu, 2004-06-24 at 12:30, Gerardo Castillo wrote:
> I have postgresql-7.4.3-1 in windows xp professional sp1 and
> Postgresql was installed with "--locale=es_ES". parameter
> My problem is with the upper function. When I use it with special
> characters like , it doesn't convert the case properly.
> select upper('a');
> result is: A (OK)
> but ,
> select upper('');
> result is: (It should be )
> I'd really appreciate any help.
In response to
pgsql-cygwin by date
|Next:||From: Felipe Santiago||Date: 2004-06-30 14:16:45|
|Subject: URGENT: Database Recovery|
|Previous:||From: mike g||Date: 2004-06-30 03:04:12|
|Subject: Re: Question about cygwin/postgres install|