Thread: BUG #2155: problem with UNICODE and KOI8

BUG #2155: problem with UNICODE and KOI8

From

"Vic"

Date:

08 January 2006, 13:57:45

The following bug has been logged online:

Bug reference:      2155
Logged by:          Vic
Email address:      vic@stream.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 Ð·Ð°Ð¿Ð¸ÑÑ)

Re: BUG #2155: problem with UNICODE and KOI8

From

Volkan YAZICI

Date:

08 January 2006, 14:27:16

On Jan 06 10:13, Vic wrote:
> Database have enconding UNICODE.
> Client have KOI8,
> "lower" function not convert to lower case any russian worlds,
> but english words convertable:

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/patches_hold/msg00235.html

Regards.