List Manager Forum

Alphabetical Order field of Persian(farsi)

User moon_1335 2014-01-06 07:20:53

how i can fix it Alphabetical Order field of persian?
i create a project list students.
when i want sort or order lastname use language farsi(Persian),just sort of arabi correct ,but not correct for farsi(persian)
how do can fix it?please help me.

User moon_1335 2014-01-06 07:41:37

Alphabetical Order arabic : Right to Left this order or sort alphabetical arabi:
ا ب ت ث ج ح خ د ذ ر ز ش س ص ض ط ظ ع غ ف ق ك ل م ن ه و ي


Alphabetical Order Persian : Right to left this order or sort persian :
ﺍ ب پ ﺕ ﺙ ﺝ ﭺ ﺡ ﺥ ﺩ ﺫ ﺭ ﺯ ژ ﺱ ﺵ ﺹ ﺽ ﻁ ﻅ ﻉ ﻍ ﻑ ﻕ ک گ ﻝ ﻡ ﻥ و ﻩ ﻯ

Moonsoft support 2014-01-06 11:12:17

Hello,

Character order in list is defined by collation in mysql tables. You should check table collation specially in #__listmanager_values and #__listmanager_field_multivalue.
You could check database collation using any mysql manager like phpmyadmin, clicking on table on the left side and in operations tab on the right.

In your case you may use utf8_persian_ci as collate.

Hope this helps. Regards,

User moon_1335 2014-01-06 11:36:53

Thank you so much
this fix and you correct about Sql.

With Regards,
Morteza

...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!
...
Support/development 10 hours

Get a bigger amount of hours for more complex tasks and get a 10% discount

Buy now!