Sorting letters in CZech

[nicronom]

Realy BIG PROBLEM czech users!

In czech alphabet is  letter Š(&#138  or alt+0138),š (&#154  or  
alt+0154), the problem is with sorting some datas with this 
letter in front. 
For example names are:
Adam, Frank, Eve, Martin, Zoe, Šomin , William, Steve 

if you sort it (normaly) it should looks like this:
Adam
Eve
Frank
Martin
Steve
Šomin
William
Zoe

but sorting in MySQL looks like this:
Adam
Eve
Frank
Martin
Steve
William
Zoe
Šomin


it is same with lower-case version  of Š.
This letter stands after letter S.

You should/could repair this cause when user has for example 
database with items in shop and he will print it all item 
starting with š or Š will be on the end of output. I managing 
company database with all our workers and co-workers and my boss 
is angry cause of this. I have to sort it manualy, it is not a 
fun.


So, please repair it or, reply to me with solution of this prob.
                               Thanx a lot, Mike

--------------------
ZDARMA a RYCHLÉ zasílání SMS z www.posliSMS.cz





---------------------------------------------------------------------
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