how can i detect and convert below strings to readable string this strings?
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
this online service resolve our problem, which with that we can convert Unicode
to correct readable characters