The following bug has been logged online:

Bug reference: 2155
Logged by: Vic
Email address: vic (AT) stream (DOT) net.ua
PostgreSQL version: 8.0.5
Operating system: FreeBSD 6.0
Description: problem with UNICODE and KOI8
Details:

Database have enconding UNICODE.
Client have KOI8,
"lower" function not convert to lower case any russian worlds, but english
words convertable:


acct=> \encoding KOI8
acct=> select lower('Проверка');
lower
----------
Проверка
(1 запись)

acct=> select lower('Test');
lower
-------
test
(1 запись)

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

On Jan 06 10:13, Vic wrote:
This is a known problem related with multi-byte characters. There's
a submitted patch pending for a complete review. We're using it here
for Turkish characters (in both UTF-8 and LATIN5 encodings) without
any problem.

Further discussion and details are here:
http://candle.pha.pa.us/mhonarc/patc.../msg00235.html


Regards.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly