Carlos Moreno <moreno_pg@xxxxxxxxxxx> 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
