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-12 14:27:31
Message-ID: 15653.1113316051@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:
> The problem is:
> - with a text 'magri'
> - the upper('magri') returns MAGRI
> - NOTE that the characters '' and '' didn't change the case.

This is determined by your locale (specifically LC_CTYPE) not by what
the database thinks the encoding is. You'll probably want to re-initdb
in the desired locale.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Reuly Bússolo Mendes 2005-04-12 14:39:29 Re: Problem in order by
Previous Message Tom Lane 2005-04-12 14:09:01 Re: db restore eats too much memory