Re: BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic

Hi Tom,
thanks for reply.
> Perhaps you don't have the database locale/encoding set correctly?

test1=# show server_encoding;
server_encoding
-----------------
UTF8
(1 row)

> (Look at the lc_collate and lc_ctype settings, and compare to what
> you were using in 8.4.)
the 8.4 setup is gone :(
>
> Another possibility is that you changed machines and the new OS
> doesn't have the right Cyrillic locale definition. PG mostly depends
> on the OS' locale features to implement things like case folding.
Here is my locale settings:

~# locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE=C
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

--

Best regards ,
Martin Vassilev
Network/System Administrator

Net-Surf.net Ltd.
phone: + 359 96 399994
e-mail: mv(at)netsurf(dot)bg
http://www.netsurf.bg