Support for UTF-8 (Arabic character set) - Klaros Test Management - Forum - Klaros Test Management
Support for UTF-8 (Arabic character set)
Musa Haidari, modified 4 Years ago.
Support for UTF-8 (Arabic character set)
Youngling Posts: 6 Join Date: 5/22/19 Recent Posts
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.
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.
Torsten Stolpmann, modified 4 Years ago.
RE: Support for UTF-8 (Arabic character set) (Answer)
Jedi Council Member Posts: 755 Join Date: 2/12/09 Recent Posts
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
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
Musa Haidari, modified 4 Years ago.
RE: Support for UTF-8 (Arabic character set)
Youngling Posts: 6 Join Date: 5/22/19 Recent Posts
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
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
Torsten Stolpmann, modified 4 Years ago.
RE: Support for UTF-8 (Arabic character set)
Jedi Council Member Posts: 755 Join Date: 2/12/09 Recent Posts
Dear Musa,
glad to hear this now works for you.
Regards,
Torsten
glad to hear this now works for you.
Regards,
Torsten