Back

Support for UTF-8 (Arabic character set)

Toggle
Dear team,
Hope you have had a great day.
We are having trouble by entering Arabic characters into the database (mysql). When we enter the same, the front end shows unreadable (which means the characters entered are not supported).
We have changed the encoding of mysql database but yet no use. Could you please help us in this regard?
Thank you in advance.
0 (0 Votes)

RE: Support for UTF-8 (Arabic character set)
Answer
6/16/19 10:35 PM as a reply to Musa Haidari.
Dear Musa,

I tried to add Arabian characters on our demo instance at https://www.klaros-testmanagement.com/demo
and it worked as expected. Look for the single test case in Project P04314.

Most probably there is a problem with the database configuration on your side.

Please note that MySQL keeps a different collation both on the database level and again per table.
Did you make sure that the tables in your database also have an UTF8-Collation?

A different collation is nothing you can change easily with an existing database but it is possible in most cases.

Also we currently do not support RTL direction of text output out of the box, which you probably want to have when using Arabian language. But we can check how easily this could be supported in a future release.

Are you planning to provide a translated message bundle for Arabian as well to have proper localization?

Please let me know your results and if I can add to this.

Regards,

Torsten
0 (0 Votes)

RE: Support for UTF-8 (Arabic character set)
Answer
6/18/19 6:24 AM as a reply to Torsten Stolpmann.
Dear Torsten,
Our team just rechecked the database and found in addition to changing the collation of the database and tables, the following two global variables's collations should be changed so we get the correct ÜTF-8 support:

@@character_set_database
@@collation_database

After changing these two, our problem was fixed. Thank you for the attention and efforts.

Regards
Musa Haidari
0 (0 Votes)

RE: Support for UTF-8 (Arabic character set)
Answer
6/18/19 9:23 AM as a reply to Musa Haidari.
Dear Musa,

glad to hear this now works for you.

Regards,

Torsten
0 (0 Votes)