Problem print unicode and arabic character

Question

I have stored in my database some string Unicode and Arabic in the correct form this is the screen of query select

when I have used on my code echo $data;

can you help me show the same data, please

Thank you so much

Next time could you accept the duplicate instead of posting thanks in the comments, please? It means the same to us and helps others. — Dharman, Sep 11 '19 at 20:31
The question marks happen when `INSERTing`. See https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored Please provide `SHOW CREATE TABLE` — Rick James, Sep 11 '19 at 20:46

score 0 · Answer 1 · answered Sep 11 '19 at 20:27

0

To show UTF-8 content in your HTML, you need to ensure your text is actually in UTF-8 at three stages:

1- The database (which is already good in your case)

2- The PHP query result:

For this, add charset=UTF8; to your database connection string, e.g.:

...Database=myDataBase;User=myUsername;Password=myPassword;charset=UTF8;

3- The HTML output:

For this, add thismeta tag to your HTML document's head:

<meta charset="utf-8">

answered Sep 11 '19 at 20:27

Anis R.

$this->connection = new PDO("mysql:charset=utf8mb4; host=" . $host . "; dbname=" . $db, $user, $pass); – applicona Sep 11 '19 at 20:30

1 Answers1