ORDER BY in MYSQL ? 8(
| From: | Jens Nedal | Date: | Fri, 18 May 2001 07:33:46 +0000 |
| Subject: | ORDER BY in MYSQL ? 8( | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9421@lists.php.net to get a copy of this message | ||
question:
Do any of you knwo how to correctly sort output from a query that contains
"Umlaut" like " Ä Ö Ü" etc. so that it looks like this:
A
Ä
B
C
D
....
O
Ö
P
R
....
and not like MYSQL does it now with the ORDER BY function, which puts all
the "Umlaut" at the end like this:
A
B
C
D
...
O
P
R
...
Z
Ä
Ö
thx in advance for any suggestions. I didn't find anything in the
manualunder the ORDER BY documentation, but maybe myasql can configure the
kind of sort in prefs or such? =)
Jens Nedal
----
So long and thx for the fish!