"Evgeny Gridasov" <eugrid(at)fpm(dot)kubsu(dot)ru> 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
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Michael Fuhr||Date: 2006-02-15 18:20:43|
|Subject: Re: BUG #2260: PGCrypto Memory Problem|
|Previous:||From: Tom Lane||Date: 2006-02-15 17:39:39|
|Subject: Re: BUG #2263: corrupted pgstat.stat file |