3 messages in com.mysql.lists.bugsSorting by alfabeth
FromSent OnAttachments
Runar Skraastad04 Jun 2002 12:42 
Gurhan Ozen04 Jun 2002 14:40 
Sinisa Milivojevic10 Jun 2002 05:30 
Subject:Sorting by alfabeth
From:Runar Skraastad (ru@start.no)
Date:06/04/2002 12:42:26 PM
List:com.mysql.lists.bugs

Hi!

The ISP i use provides a MySQL db (3.23.47) I use it to train making db based webpages with PHP and MySQL. I discovered that whan i use order by in tekst fields it orders wrong by the 3 last letters in the nordic (Æ,æ Ø,ø and Å,å)The real order is æ ø å (Æ Ø Å) but MySQL reports å æ ø

How-To-Repeat: To reproduce it you only nead a tabel with varchar field nad data where these three letters vill make the differense in the alfabethsation. Use order by <fieldname>

RuS