From: | amk(at)gmx(dot)at |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | |
Date: | 2002-01-14 15:05:37 |
Message-ID: | 4001.1011020737@www57.gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter E. Chen | 2002-01-14 15:10:27 | Anyway to know which users are connected to postgres? |
Previous Message | Michael Meskes | 2002-01-14 15:05:34 | gborg |