Daniel Cristian Cruz <danielcristian@xxxxxxxxx> writes: > I found this problem, where 'ã' MUST be ILIKE '�' (PostgreSQL 8.2.12, RedHat > x86_64): Is your database encoding iso88591? IIRC, 8.2 will try to warn you if the encoding doesn't match the locale setting, but it doesn't completely refuse nonsensical combinations. However, a nonsensical combination could easily cause bad results from upper(). regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin