51
You could try this (altough it's a wierd way to do it, it should work).
1. Dump your MySQL database to a file on your pc;
2. Make a copy of the dump file (as backup);
2. Open the file with Notepad++;
3. Click on Format > Convert to UTF-8 without BOM;
4. Save the file;
5. Import the converted dump file in your database;
6. Run this php script:
7. Or if it still didn't work you could try this script:
Didn't try it but it's a combination of converting methods i found with google.
Greets Dylian.
<?php
// Database info
$dbhost = 'localhost';
$dbuser = 'db_user';
$dbpass = 'password';
$dbname = 'db_name';
//---------------
header('Content-type: text/plain');
$dbconn = mysql_connect($dbhost, $dbuser, $dbpass) or die( mysql_error() );
$db = mysql_select_db($dbname) or die( mysql_error() );
mysql_query("SET CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'", $db);
mysql_close($dbconn);
?>
<?php
// Database info
$dbhost = 'localhost';
$dbuser = 'db_user';
$dbpass = 'password';
$dbname = 'db_name';
//---------------
header('Content-type: text/plain');
$dbconn = mysql_connect($dbhost, $dbuser, $dbpass) or die( mysql_error() );
$db = mysql_select_db($dbname) or die( mysql_error() );
$sql = 'SHOW TABLES';
$result = mysql_query($sql) or die( mysql_error() );
while ( $row = mysql_fetch_row($result) )
{
$table = mysql_real_escape_string($row[0]);
$sql = "ALTER TABLE $table DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci";
mysql_query($sql) or die( mysql_error() );
print "$table changed to UTF-8.n";
}
mysql_close($dbconn);
?>
(i guess i'm doing something wrong).
.
