Skip site navigation (1) Skip section navigation (2)

Re: An idea on faster CHAR field indexing

From: Giles Lean <giles(at)nemeton(dot)com(dot)au>
To: "Randall Parker" <randall(at)nls(dot)net>
Cc: "PostgreSQL-Dev" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: An idea on faster CHAR field indexing
Date: 2000-06-22 11:41:40
Message-ID: (view raw or whole thread)
Lists: 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

    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:

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

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.



pgsql-hackers by date

Next:From: Giles LeanDate: 2000-06-22 11:58:08
Subject: Re: Big 7.1 open items
Previous:From: Hiroshi InoueDate: 2000-06-22 11:09:07
Subject: RE: Big 7.1 open items

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group