1.

How to convert a string to utf 8 in MySQL?

Answer»

Here’s a code script to convert string data to UTF 8 in your database:

HEADER('Content-Type: text/plain; charset=utf-8');
$databasesToConvert = [ 'database1' */ ];
$typesToConvert = [ 'char', 'varchar', 'tinytext', 'mediumtext', 'text', 'longtext'];
CONVERT(CAST(CONVERT(`{$column}` USING ENGLISH) AS BINARY) USING utf8)";
$query = "UPDATE `{$table}` SET " . join( ', ', $converts );
echo "\N", $query, "\n";
echo "\n";
 


Discussion

No Comment Found

Related InterviewSolutions