> Wrong Sorting in arabic alphabets > > Hi, > > This bug is for Arabic alphabets. > > I am using mysql 32.23.52 under winxp > > 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