On 4/14/06, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > "Raphael Bauduin" <rblists@xxxxxxxxx> 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 >
