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

Re: [HACKERS] Re: [PATCHES] Postgres-6.3.2 locale patch

From: Patrice Hédé <patrice(at)idf(dot)net>
To: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: phd2(at)earthling(dot)net, Postgres Hackers List <hackers(at)postgreSQL(dot)org>, Jose Soares Da Silva <sferac(at)bo(dot)nettuno(dot)it>, Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Subject: Re: [HACKERS] Re: [PATCHES] Postgres-6.3.2 locale patch
Date: 1998-06-03 15:36:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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 :)


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(at)idf(dot)net -----
                     ... Looking for a job in Iceland or in Norway !
Ingénieur informaticien   -   Computer engineer   -   Tölvufræðingur
----- ----------------------------------

In response to

pgsql-hackers by date

Next:From: The Hermit HackerDate: 1998-06-03 15:52:35
Subject: Re: [HACKERS] keeping track of connections
Previous:From: AliEDate: 1998-06-03 14:52:07
Subject: unsubscribe

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