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
