PG 8.2 change Letter Sort Order

From: jkohlmeier(at)pronet-systeme(dot)de
To: pgsql-admin(at)postgresql(dot)org
Subject: PG 8.2 change Letter Sort Order
Date: 2008-02-05 15:54:25
Message-ID: DIIE.00000104000075D3@reliant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mike Williams 2008-02-05 16:08:16 Re: "create implicit sequence" crashes postgres
Previous Message Mike Williams 2008-02-05 13:24:12 Re: "create implicit sequence" crashes postgres