PG 8.2 change Letter Sort Order

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux