"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