From: Hannu Krosing <hannu@tm.ee>
To: Tim Uckun <tim@diligence.com>
Cc: pgsql-hackers@postgresql.org, Oleg Bartunov <oleg@sai.msu.su>
Subject: Re: Creating locales.
Date: Sat, 30 Dec 2000 13:43:30 +0200
Message-ID: <3A4DCA62.504066F1@tm.ee> (raw)
References: <200012270556.AAA19258@candle.pha.pa.us>
<00b801c07021$7b33d500$330a0a0a@6014cwpza006>
<4.2.0.58.20001227101626.00a4bc28@mail.diligence.com>
Tim Uckun wrote:
>
> I have been searching without luck on a howto on how to create locales for
> postgres. Could somebody please point me in the general direction? Thanks.
>
PostgreSQL uses system locales (even to the extent that I was unable to
get
it use any other locale by setting LC_* variables in
/etc/init.d/rc.d/postgres)
I did have to modify my locale (et_EE) to _not_ group \xff (ÿaut;)
with
other y-s but to sort it after all other "standard" chars to work
properly
with LIKE optimisations. Perhaps the right approach would be to leave
\xff
alone and to choose some character in the 128-159 range for
bigger-than-any-other-char but as \xff is not used in estonian i was
able
to do away with just moving it.
OTOH, it may be a good idea to start a repository for locales that are
specifilally modified to work well with postgres.
We may want to move the locale stuff inside the backend someday as
mandated
by SQL standards and then some work would be already done.
--------
Hannu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: hannu@tm.ee, tim@diligence.com, oleg@sai.msu.su
Subject: Re: Creating locales.
In-Reply-To: <3A4DCA62.504066F1@tm.ee>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox