Re: BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic - Mailing list pgsql-bugs

From Martin Vassilev
Subject Re: BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic
Date
Msg-id 2263533.y3eBCCWX9p@mv-office
Whole thread Raw
In response to Re: BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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@netsurf.bg
http://www.netsurf.bg

pgsql-bugs by date:

Previous
From: correio.vip@gmail.com
Date:
Subject: BUG #9736: incomplete odbc
Next
From: kochismo@gmail.com
Date:
Subject: BUG #9737: Trigram Regex degenerate case