Обсуждение: BUG #2155: problem with UNICODE and KOI8

Поиск
Список
Период
Сортировка

BUG #2155: problem with UNICODE and KOI8

От
"Vic"
Дата:
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

От
Volkan YAZICI
Дата:
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.