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

Reply via email to