I am surprised with the sorting order with Urdu language in MS Access 2013 (Windows 10).
I am developing an Access programme with some columns in Urdu language and when i sort the column (or field) having Urdu characters, it really disappointing me.
I believe this is not the issue of windows' version, it is purely the issue of Access, because when I pasted these alphabets in ms Word and sorted them, everything was correct.
This is how it is sorting:
ء ا ب پ ت ث
ج چ ح خ د ذ
ر
ز
ژ س
ش
ص
ض
ط ظ
ع
غ
ف ق
گ
ل
م
ن
و
ٹ
ڈ
ڑ
ک
ہ
ی
ے
The correct sorting order is as follows:
ا ب پ ت ٹ ث ج چ ح خ د ڈ ذ ر ڑ ز ژ س ش ص ض ط ظ ع غ ف ق ک گ ل م ن و ہ ء ی ے
Thanks for any help.
