Thursday, February 22, 2007

MySQL 中文亂碼

先在 my.ini 中

[mysqld]
default-character-set=latin1

[client]
default-character-set=utf8
init_connect='SET NAMES utf8'

and
建立一個 mysql connection 檔案
這裏是 for PHP only:
<?
//database connection details.
$host = "localhost";
$link = mysql_connect($host, "login_name", "login_pw");
mysql_query("SET NAMES 'utf8'");
mysql_select_db("table_name", $link);
?>

ref: d.Cat blog