Search code examples
phpsqlarabicfarsi

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


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


Solution

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

    online service link