On 4/14/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Raphael Bauduin" <rblists@gmail.com> writes:
> > Does the ilike operator work fine with cyrillic text put in a UTF-8
> > encoded database?
>
> If you've initdb'd in an appropriate locale (probably named something
> like ru_RU.utf8) then it should work. I wouldn't expect a random
> non-Russian locale to necessarily know about Cyrillic case conversions,
> however.
The problem is that the system is serving, at the same time, content
for different locales, so I can't set it at the environment level.
Maybe I should set a user setting so a user can choose which locale to
use.
Thanks for the help!
Raph
>
> Martijn's nearby comment about OS dependency really boils down to the
> fact that different OSes may have different definitions for similarly
> named locales. We need to know what locale you're using (try "SHOW
> LC_CTYPE") as well as the OS.
>
> regards, tom lane
>