Realy BIG PROBLEM czech users! In czech alphabet is letter Š(Š or alt+0138),š (š 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