UTF-8 to HTML Character Decimal Codes before use inside code or importing in sql

Question

how can i detect and convert below strings to readable string this strings?

1. سئوالات
2. مطاعن ابوبكر
3. مطاعن عمر

since these strings with UTF-8 in MySQL database and our language is Arabic and Persian they are unreadable for us and I'm not sure how can we convert them to normal readable strings

sql table structure:

CREATE TABLE `categories` (
  ...
  `title` longtext,
  `tblname` longtext,
  ...
  PRIMARY KEY (`number`)
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8;

is there any online service or solution to convert them to readable strings before using them and importing into database?

we don't want to convert them inside php code with iconv or convert inside sql, we want to only convert them to have simple sql code before inserting into the database

Answer 1

You should use mysqli_set_charset() function before uploading/updating any string in database.

$conn = new mysqli(host,user,pass,dbname);

if($conn->connect_error){
    die("Connection failed: ".$conn->connect_error);
    exit();
}

mysqli_set_charset($conn,"utf8mb4");


// your query here

Answer 2

this online service resolve our problem, which with that we can convert Unicode to correct readable characters

online service link