The following bug has been logged online:
Bug reference: 2155
Logged by: Vic
Email address: [EMAIL PROTECTED]
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