Hello!
I use a MySQL database table to store the name of several countries in
several languages. This table is used to create a country list for a
registration form on a website. As the list contains the names in several
languages they are sorted alphabetically only in one language but not in
all of them. Now I just included an "ORDER BY country" into the SQL query
I use to fetch the data from the table in the database. However, there's a
problem with the German countrie names. There are several names that start
with special German characters (which are called umlauts). As they look
like an A with two dots, an O with two dots and an U with two dots you'd
usually find between the words starting with A, O and U in German
alphabetically sorted lists but of course this doesn't work with MySQL.
The problem is that they now appear at the end of the list but nobody will
ever find them there. Can anyone give me a hint how to solve this problem?
Christian
--
They that can give up liberty to obtain a little temporary safety
deserve neither liberty nor safety.
Benjamin Franklin
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
