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
