Persian character's issue in mysql database

Question

When I insert Persian data to database, data will save like this: †Ø¯Ø± 50 لیتری

But when I read data from database and echo it on the web, they are Ok.

I need to read data in my database directly. what is your solution?

Mysql setting:

Server connection collation: UTF8_general_ci

Html file charset is utf8.

Answer 1

I had a same issue,this code: mysqli_set_charset($con, "utf8"); solved my problem!