arabic doesn't load well even the character encoding is ut8_general_ci

Question

i would like to have an answer about the problem that am facing which is the arabic languages do load in random way in the data base and the browser (some times it does work correctly ,sometimes doesnt , by showing a multiple symbols) even i have set all the character encoding ti utf8_general_ci

Welcome to SO. Could you describe your issue in more detail, please? E.g. by adding code, commands or screen shots which describe your problem. Please have also a look to the Help Center, especially for [asking](https://stackoverflow.com/help/how-to-ask) and [minimal examples](https://stackoverflow.com/help/mcve). Thanks. — CKE, Sep 24 '18 at 10:08

Hamza Haider · Answer 1 · 2018-09-24T12:16:27.820

0

You should change your database collation in order to work with Arabic language.

For MS SQL SERVER => Go to properties of your database => Click on option tab on the left side and change your collation to Arabic_CI_AS.

For MY SQL Data in Arabic in MySQL database

This will solve your problem.

edited Sep 24 '18 at 12:16

answered Sep 24 '18 at 11:50

Hamza Haider

730
6
20

thank you so much ,but in the collation options the Arabic_CI _AS doesn't existe! – iwf Sep 24 '18 at 12:04
Welcome! Which sql server are you using? – Hamza Haider Sep 24 '18 at 12:09
i tried wamp xampp appserver , at the moment am using xampp – iwf Sep 24 '18 at 12:23
Then go with this solution https://stackoverflow.com/questions/6859018/save-data-in-arabic-in-mysql-database – Hamza Haider Sep 24 '18 at 12:26

arabic doesn't load well even the character encoding is ut8_general_ci

1 Answers1