Re: Patch for collation using ICU

Поиск
Список
Период
Сортировка
От John Hansen
Тема Re: Patch for collation using ICU
Дата
Msg-id 5066E5A966339E42AA04BA10BA706AE50A92FB@rodrick.geeknet.com.au
обсуждение исходный текст
Ответ на Patch for collation using ICU  (Palle Girgensohn <girgen@pingpong.net>)
Ответы Re: Patch for collation using ICU  (Palle Girgensohn <girgen@pingpong.net>)
Список pgsql-hackers
>
> I use this patch in production on one FreeBSD 4.10 server at
> the moment.
> With the latest version, I've had no problems. Logging is
> swithed on for
> now, and it shows no signs of ICU complaining. I'd like more
> reports on
> Linux, though.

I currently use this on gentoo with ICU3.2 unmasked.

Works a dream, even with locale C and UNICODE database.

Small test:

createdb --encoding UNICODE --locale C test
psql test
set client_encoding=iso88591;
CREATE TABLE test (t text);
INSERT INTO test (t) VALUES ('æøå');
set client_encoding=unicode;
INSERT INTO test (t) SELECT upper(t) FROM test;
set client_encoding=iso88591;
SELECT * FROM test; t
-----æøåÆØÅ
(2 rows)

Just as I'd expect, as upper/lower/initcap are locale independent for these characters.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Palle Girgensohn
Дата:
Сообщение: Re: Patch for collation using ICU
Следующее
От: "apoc9009@yahoo.de"
Дата:
Сообщение: ...