Hello,

I have a problem with ilike search operator with czech characters. It's
not working case insensitive after changing from Postgres SQL 7.3 with
ISO8829-2 encoding to PostgreSQL 8.0 with UTF-8 encoding.

I have dumped the old database, converted to from iso88295-2 to utf-8
using iconv and imported it to the new database.

I have a table "customer" with column "surname" and there is a record
with surname "ÄŒervenka" (first letter is "C" with caron). When I execute

select * from customer where surname ilike '%�er%'; -- "c" with caron

I get an empty result. After changing to capital letter I get the answer

select * from customer where surname ilike '%ÄŒer%'; -- "C" with caron

I thought it's some locale related problem, but when I use upper and
lower functions, everything is OK.

cust=# select upper('�er'), lower('ČER');
upper | lower
-------+-------
ČER | �er

When using 'order by' clause I get the data ordered correctly according
to the Czech habits. That's fine.

System locale is cs_CZ.UTF-8, database was initialized by initdb with
the same locale, postgres.conf contains

lc_messages = 'cs_CZ.UTF-8'
lc_monetary = 'cs_CZ.UTF-8'
lc_numeric = 'cs_CZ.UTF-8'
lc_time = 'cs_CZ.UTF-8'

pg_controldata returns

[postgres@acc ~]$ pg_controldata /var/lib/pgsql/data
Ä�Ã*slo verze pg_controlu: 74
LC_COLLATE (porovnávánÃ* Å™etÄ›zců): cs_CZ.UTF-8
LC_CTYPE (typy znaků): cs_CZ.UTF-8

PostgreSQL is running with environment with LANG set to cs_CZ.UTF-8

$ ps auxef | grep postmaster
/usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data USER=postgres
MAIL=/var/spool/mail/postgres
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin
INPUTRC=/etc/inputrc PWD=/var/lib/pgsql LANG=cs_CZ.UTF-8 SHLVL=1
HOME=/var/lib/pgsql LOGNAME=postgres PGDATA=/var/lib/pgsql/data


Is it a bug in PostgreSQL or am I missing something?

--
Regards,

Martin Edlman
Fortech s.r.o, Litomysl
Public PGP key: http://edas.visaci.cz/#keys

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster