Hi,
Arabic language is saved as question marks ??, could you please help me to solve this issue?
I am using MySql database and the collation is UTF8_unicode_ci
I can insert the Arabic data from table directly but from admin side the data saved as ??
Arabic language is saved as ??
- 5
- 45
- 11/12/2019
- Iran (Islamic Republic of)
I've found the solution.
First, we have to make sure about the database settings. Database, table and column collation must be set to utf8_general_ci. In order to check the collation of database, in phpMyAdmin, simply click on your database, then go to the operations tab and scroll down until reach to collation section. To check the collation of the table, click on the table and go to the structure tab and scroll down to the information section. you will find the collation of the table.
Second, we have to add CharSet=utf8; to the connection string.
First, we have to make sure about the database settings. Database, table and column collation must be set to utf8_general_ci. In order to check the collation of database, in phpMyAdmin, simply click on your database, then go to the operations tab and scroll down until reach to collation section. To check the collation of the table, click on the table and go to the structure tab and scroll down to the information section. you will find the collation of the table.
Second, we have to add CharSet=utf8; to the connection string.