Postgres Pro
Downloads
Home   >   mailing lists

Thread: PG 8.2 change Letter Sort Order

PG 8.2 change Letter Sort Order

From
jkohlmeier@pronet-systeme.de
Date:
Hello Group,
 
I have a Database for German Text using UTF-8 and want to change the sort order of Letters.
 
Creation Database:
initdb  -E UTF-8 --locale=de_DE.UTF-8 --lc-collate=de_DE.UTF-8 --lc-ctype=de_DE.UTF-8 -D DBPath
 
The Sort set with --lc-collate=de_DE.UTF-8 was not the right Sort Order ( ß=>ä=>aa=>äb). I need a sort where ß==ss and ä ==ae.
Is there an over Value for lc_collate who changes the Sort Order? (de_DE.ISO8859-1,C,POSIX dosent change it correctly
Or can i change the Sort Orders in Postgresqls Config Files? I havent found the correct ones
 
OS:
Solaris 10
PG 8.2
 
Thanks for Help
 
Jens

Re: PG 8.2 change Letter Sort Order

From
Michael Monnerie
Date:
On Dienstag, 5. Februar 2008 jkohlmeier@pronet-systeme.de wrote:
> I need a sort where ß==ss and ä ==ae.

If you find a solution, I would be interested, too.

mfg zmi
--
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net                   Key-ID: 1C1209B4
Attachment

Re: PG 8.2 change Letter Sort Order

From
Tom Lane
Date:
Michael Monnerie <michael.monnerie@it-management.at> writes:
> On Dienstag, 5. Februar 2008 jkohlmeier@pronet-systeme.de wrote:
>> I need a sort where �==ss and � ==ae.

> If you find a solution, I would be interested, too.

What you'd need is a locale definition that acts that way.

If that is a common understanding of the meaning of sorting in German,
I'd imagine someone has made one up --- but a PG list is the wrong place
to be asking about it.  We just use the operating system's locale
facilities, we don't write our own.  You'd want to find some libc or
libintl hackers ...

            regards, tom lane