发布中文的显示错误:PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value
在网上搜了一下,这个转换数据库的编码的代码是通过实践验证的,把代码放到一个php文件里,上传到根目录下,然后运行(在IE里打开),即可。
<?php
// your connection
Drupal: PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value
mysql_connect("localhost","username","userpassword");
mysql_select_db("databasename");
// convert code
$res = mysql_query("SHOW TABLES");
while ($row = mysql_fetch_array($res))
{
foreach ($row as $key => $table)
{
mysql_query("ALTER TABLE " . $table . " CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci");
echo $key . " => " . $table . " CONVERTED<br />";
}
}
?>