Re: Encoding, Unicode, locales, etc.

Carlos Moreno <moreno_pg(at)mochima(dot)com> writes:
> ... The one that does the case conversion "correctly" (read: as I
> expect it as per Spanish or French rules) is 8.1.4 with en_US locale
> (LC_CTYPE and LC_COLLATE both showing en_US.UTF-8). PG 7.4.14, *even
> with locale es_ES*, does not do the case conversion (characters with
> accent or tilde are left untouched).

IIRC, 7.4 has no chance of doing upper/lower sanely with multibyte UTF8
characters, because it only knows about the old-line toupper/tolower
<ctype.h> functions. 8.0 and up know about <wctype.h> and can do this
as you'd expect. See the CVS history at
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/oracle_compat.c

regards, tom lane