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.