Wrong Sorting in arabic alphabets Hi,
This bug is for Arabic alphabets. I am using mysql 32.23.52 The error is : When sorting a table ASC it puts the letter (mem ميم) in the top. The letter (mem ميم) is the 24 alphabets Example 1 – جرير (first letter is jeem – جيم - number 5 in the alphabets ) 2 – علقمة (first letter is aeen – عين - number 19 in the alphabets) 3 – فرزدق (first letter is faa – فاء number 21 in the alphabets) 4 - مقنع (first letter is mem – ميم number 24 is the 24 alphabets) this is the correct sort, but mysql sort it : 4 - مقنع (first letter is mem – ميم number 24 is the 24 alphabets) 1 – جرير (first letter is jeem – جيم - number 5 in the alphabets ) 2 – علقمة (first letter is aeen – عين - number 19 in the alphabets) 3 – فرزدق (first letter is faa – فاء number 21 in the alphabets) Is there a solution? __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com --------------------------------------------------------------------- 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