Hello Postgres Gurus!
In the German language we have special characters like
Ä (Ä), Ö (Ö), Ü (Ü), ß (ß) and so on.
I have 5 entries in a table "entries" with one varchar column "name":
select name from entries;
Birnen
Äpfel
Öl
Essig
Salz
I like to sort these entries by name:
select name from entries order by name;
Birnen
Essig
Salz
Äpfel
Öl
But instead of using the standard alphabet
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Ä Ö Ü ß
for sorting the strings I would like to use the German alphabet
A Ä B C D E F G H I J K L M N O Ö P Q R S ß T U Ü V W X Y Z
to get the correct (sorted by German alphabet) result:
this would be my preferred result: ==>
select name from entries order by name;
Äpfel
Birnen
Essig
Öl
Salz
Can I do this with PostgreSQL?
Thanks,
Alex
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net