Skip site navigation (1) Skip section navigation (2)

Re: upper and UTF-8

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Benjamin Krajmalnik <kraj(at)servoyant(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: upper and UTF-8
Date: 2010-07-27 03:12:08
Message-ID: AANLkTikRCdVyppWTztO1ocY9DBd1jQWPecG_K9yZLR6G@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, Jul 26, 2010 at 8:09 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com> wrote:
> Excerpts from Benjamin Krajmalnik's message of lun jul 26 17:03:54 -0400 2010:
>> I just used the upper(text) function on a database which is utf8 encoded
>> and which has spanish text.
>>
>> All of the regular characters were properly converted, except for
>> characters which had accents.
>
> FWIW it works fine for me:
>
> alvherre=# show lc_collate ;
>  lc_collate
> ------------
>  es_CL.utf8
> (1 fila)
>
> alvherre=# select upper('benjamín');
>  upper
> ----------
>  BENJAMÍN
> (1 fila)
>
> I suspect that the problem is an incorrect client_encoding setting.

Yeah, OP had set lc_collate to C under the mistaken impression that
collation controlled the character sets you could insert into the
database.  If you create a db with lc_collate='C' then the upper only
works on basic ascii characters near as I can tell.

In response to

Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2010-07-27 03:36:33
Subject: Re: upper and UTF-8
Previous:From: Alvaro HerreraDate: 2010-07-27 02:09:36
Subject: Re: upper and UTF-8

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group