Wrong Sorting in arabic alphabets

ï¿½ï¿½ï¿½ Sat, 31 Aug 2002 15:27:32 -0700

>  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

Wrong Sorting in arabic alphabets

Reply via email to