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
[EMAIL PROTECTED] ~]$ 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
