Re: Sorting Problem - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Sorting Problem
Date
Msg-id 3F3A75CC.5080007@cvc.net
Whole thread Raw
In response to Re: Sorting Problem  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: Sorting Problem  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
If we really want to do it, we won't have to do the grunt work ourselves, just the tie-in, and Postgres specific
implementation:

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

Stephan Szabo wrote:

> On Wed, 13 Aug 2003, Dennis Gearon wrote:
>
>
>>Got a link to that section of the standard, or better yet, to a
>>'interpreted' version of the standard? :-)
>
>
> The standard draft yes, an interpreted version, unfortunately not (unless
> Date's book covers it and I can find where my copy is.
>
> Here are some of the highlights
>
> ----
>          k) form-of-use: A convention (or encoding) for representing
> characters (in character strings). Some forms-of-use are
> fixed-length codings and others are variable-length codings.
>
>          l) form-of-use conversion: A method of converting character
> strings from one form-of-use to another form-of-use.
>
> ----
>          A character set is described by a character set descriptor. A
> character set descriptor includes:
>
>          -  the name of the character set or character repertoire,
>
>          -  if the character set is a character repertoire, then the name of
>             the form-of-use,
>
>          -  an indication of what characters are in the character set, and
>
>          -  the name of the default collation of the character set.
>
>          For every character set, there is at least one collation. A
> collation is described by a collation descriptor. A collation descriptor
>          includes:
>
>          -  the name of the collation,
>
>          -  the name of the character set on which the collation operates,
>
>          -  whether the collation has the NO PAD or the PAD SPACE attribute,
>             and
>
>          -  an indication of how the collation is performed.
>
> ---
>
> The character data types and literals can include a character set
> definition. Character type columns can include a collation.  There's a
> COLLATE <blah> clause that looks like it can be used in expressions as
> well.
>
>


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Sorting Problem
Next
From: Gianni Mariani
Date:
Subject: Re: Sorting Problem