Laukó Péter dijo:
>
> Hi list,
> can anyone tell me why the characters with accents are not changed by lower and upper? Is it a bug, or should I
configureanything else than the db encoding???
Huh, they do in my version ("developer" version). They should also work
in current stable version, AFAIK.
pg_controldata here gives amongst other things (this should be in
contrib/ in your version):
$ pg_controldata
[... some things ...]
LC_COLLATE: es@tradicional
LC_CTYPE: es@tradicional
$ psql regression -c "select upper('ñáí')"
upper
-------
ÑÁÍ
(1 row)
It should be a matter of setting the locale at initdb time.
--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Hoy es el primer dia del resto de mi vida"