postgresql server starts with environment: LC_COLLATE=en_US.UTF-8 LC_ALL=en_US.UTF-8 LANG=en_US.UTF-8
I've tried to set different LC_COLLATE/LC_ALL/LANG settings but it did not help. I've tried to change my psql input to unicode russian, but it did not help, too. 'show all' says I've got lc_collate and other lc_* set to en_US.UTF-8. initdb was run with this locale. It cannot be modified setting it in postgresql.conf (creation db constant?) Should I reinit database to get this working or what? If I should reinit db, what locale should I choose? BTW, ~* syntax does not also work with upper/lower case russian letters, while upper()/lower() still work ok. On Wed, 15 Feb 2006 12:44:18 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > "Evgeny Gridasov" <[EMAIL PROTECTED]> writes: > > my terminal is RU_ru.KOI8-R, > > template1's encoding is UTF8. > > ILIKE seems to be buggy when comparing russian strings, > > while UPPER/LOWER works OK. > > I'll bet that the database's locale setting is expecting some encoding > other than UTF8 :-(. You need to have compatible locale and encoding > settings inside the database. You didn't say exactly what the database > LC_COLLATE value is, but if it's RU_ru.KOI8-R, that definitely does not > match UTF8. > > regards, tom lane -- Evgeny Gridasov Software Engineer I-Free, Russia ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
