Re: Lower case

"Vladimir S. Petukhov" <vladimir@sycore.org> writes:
> pg_controldata /var/pgsql/data
> ...
> LC_COLLATE:                           ru_RU
> LC_CTYPE:                             ru_RU

> bash-2.05b# psql -l
>         List of databases
>    Name    |  Owner   | Encoding
> -----------+----------+----------
>  testdb   | postgres | UNICODE

> And LIKE, ILIKE, ~ do not recognize upper/lower case..

What character encoding is implied by those LC_ settings on your machine?
If it's different from the database encoding (here utf8) these things
won't actually work right.

Also, before PG 8.0 upper/lower simply don't work on multibyte characters,
which means you'd have to use a single-byte encoding to make it work
(I think koi8 is single-byte but not sure).

            regards, tom lane