Re: [HACKERS] Re: [PATCHES] Postgres-6.3.2 locale patch - Mailing list pgsql-hackers

From Patrice Hédé
Subject Re: [HACKERS] Re: [PATCHES] Postgres-6.3.2 locale patch
Date
Msg-id Pine.LNX.3.96.980603172935.30033A-100000@paris.ivo.fr
Whole thread Raw
In response to Re: [PATCHES] Postgres-6.3.2 locale patch  ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>)
List pgsql-hackers
Hi Tom,

> I would propose to do this for v6.4 as user-defined packages (with
> compile-time parser support) on top of the existing USE_LOCALE and MB
> patches so that the existing compile-time options are not changed or
> damaged.

Be careful that system locales may not be here, though you may need the
locale information in Postgres. They may also be broken (which is in fact
often the case), so don't depend on them.

> So, the initial questions:
>
> 1) Is the NCHAR/NVARCHAR/CHARACTER SET syntax and usage acceptable for
> non-English applications? Do other databases use this SQL92 convention,
> or does it have difficulties?

Don't know (yet).
>
> 2) Would anyone be interested in helping to define the character sets
> and helping to test? I don't know the correct collation sequences and
> don't think they would display properly on my screen...

I can help for french, icelandic, and german and norwegian (though for the
two last ones, I guess there are more appropriate persons on this list :).

> 3) I'd like to implement the existing Cyrillic and EUC-jp character
> sets, and also some European languages (French and ??) which use the
> Latin-1 alphabet but might have different collation sequences. Any
> suggestions for candidates??

They all have, as soon as we take care of accents, which are all put at
the end with an english system. And of course, they are different for each
language :)

Patrice

PS : I'm sorry, Tom, I haven't been able to work on the faq for the past
month :(( because I've been busy in my free time learning norwegian ! I
will submit something very soon, I promise !

--
Patrice HÉDÉ --------------------------------- patrice@idf.net -----
                     ... Looking for a job in Iceland or in Norway !
Ingénieur informaticien   -   Computer engineer   -   Tölvufræðingur
----- http://www.idf.net/patrice/ ----------------------------------


pgsql-hackers by date:

Previous
From: AliE@atlas.com
Date:
Subject: unsubscribe
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] keeping track of connections