Re: upper and UTF-8

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.