|
| mySQL doesn't sort Arabic character correctly, unless... |  
|
|---|
Product:
Delphi all versions | Category:
Database-SQL | Skill Level:
 | Scoring:  | Last Update:
04/07/2002 | Search Keys:
delphi delphi3000 article borland vcl code-snippet mySQL Arabic binary sort duplicate | Times Scored:
5 | Visits:
3972 | Uploader: Waheed Alsayer
Company: Shamayel Computer Systems | Reference: N/A | | | Question/Problem/Abstract:
Why doesn't mySQL sort Arabic characters correctly? | Answer:
When you use VARCHAR fields in mySQL database server for Arabic text then you try to sort using this field you will not get the correct sorting order.
Not only that, when I tried to insert a number of records, I got a dublicate error. There was no duplicate records.
Solution: Change all VARCHAR field to use BINARY type fields. So they should all be VARCHAR BINARY. This should solve the problem.
|
|
|
| |
Sign up to consume product discounts for Bronze memberships !
|
|
| |
Community Ad of
A. B. Talal |
|
| |
|
|
|
Sign Up
