Re: An idea on faster CHAR field indexing

Поиск
Список
Период
Сортировка
От Giles Lean
Тема Re: An idea on faster CHAR field indexing
Дата
Msg-id 12860.961674100@nemeton.com.au
обсуждение исходный текст
Ответ на Re: An idea on faster CHAR field indexing  ("Randall Parker" <randall@nls.net>)
Список pgsql-hackers
[ I hope this is useful for the archives, even though it's pretty much been covered already. --giles ]

> With Unicode you have to have a collation order that cuts across
> what use to be separate character sets in separate code pages.

From the glossary at http://www.unicode.org/glossary/index.html:

Collation   The process of ordering units of textual information. Collation is   usually specific to a particular
language.Also known as   alphabetizing or alphabetic sorting. Unicode Technical Report #10,   "Unicode Collation
Algorithm,"defines a complete, unambiguous,   specified ordering for all characters in the Unicode Standard.
 

The "Unicode Technical Report #10" is accessible at:

http://www.unicode.org/unicode/reports/tr10/

This technical report provides a way to specify "the tailoring for any
particular country" which together with the standard ordering will
allow different Unicode implementations to sort any particular input
identically.

Summary is that Unicode still has locales and we still have to know
not only the character set/code page but also the locale ("country
specific tailoring") an index was created with to use it.

Regards,

Giles



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

Предыдущее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: Big 7.1 open items
Следующее
От: Giles Lean
Дата:
Сообщение: Re: Big 7.1 open items