From: jkohlmeier@pronet-systeme.de
To: pgsql-admin@postgresql.org
Subject: PG 8.2 change Letter Sort Order
Date: Tue, 5 Feb 2008 15:54:25 +0000
Message-ID: <DIIE.00000104000075D3@reliant> (raw)
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
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-admin@postgresql.org
Cc: jkohlmeier@pronet-systeme.de
Subject: Re: PG 8.2 change Letter Sort Order
In-Reply-To: <DIIE.00000104000075D3@reliant>
* 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