Re: postgresql unicode lower/upper problem - Mailing list pgsql-general

Sergey Levchenko <sector119@gmail.com> writes:
> I am not able to get work lower and upper functions on postgresql
> v8.0.1 and 8.1b(current cvs copy). I use Debian SID i686 GNU/Linux.
> Locale: ru_RU.KOI8-R

> createdb -E UNICODE test

I think the problem is you selected a database encoding that doesn't
match what the locale expects.  You can't really mix-and-match if you
expect locale-specific stuff like upper/lower to work.  For that
locale you must use -E KOI8.

            regards, tom lane