Arabic characters being displayed as question marks

Question

I've inserted arabic characters into my database and as they're being displayed as question marks

I use SafeMySQL class to connect to the database and I set my charset to utf8 All my tables are set to utf8_general_ci and my database is also set to utf8_general_ci

I force a utf8 encoding in htaccess and inside the html

Does anyone have any idea what may have been left out of this that is still displaying arabic characters as question marks?

Are they displaying as question marks or were they stored as question marks? — Noah, Jul 09 '14 at 23:29
Try inserting the data through phpmyadmin directly. You'll have to check each column of the tables — Noah, Jul 09 '14 at 23:38
Warning: #1366 Incorrect string value: '\xD9\x85\xD8\xAB\xD8\xA7...' for column 'report_message' at row 1 @Noah — Ali, Jul 09 '14 at 23:41
http://stackoverflow.com/questions/279170/utf-8-all-the-way-through — dave, Jul 10 '14 at 00:40
You may also need to set the connection to the database to utf8. — Syed Hussim, Jul 10 '14 at 00:54

score 0 · Answer 1 · answered Dec 18 '16 at 14:51

I am the author of SafeMysql. By default this library is using utf8 encoding, so there should be no problem with database connection encoding, unless you are explicitly setting some other encoding.

From the error message you gave in comments,

Warning: #1366 Incorrect string value: '\xD9\x85\xD8\xAB\xD8\xA7...' for column 'report_message' at row 1

I would say that you have to double-check your table's (and fields) charset.

Run the following query and see, if the table's definition indeed contain utf8 in all respective places:

DESCRIBE TABLE table_name

Arabic characters being displayed as question marks

1 Answers1