MySQL設定預設UTF-8讀寫

[1] vi /etc/my.cnf

[client]
default-character-set=utf8

# 以下四版以上才有支援
[mysqld]

default-character-set=utf8

# ci代表大小寫沒差
default-collation=utf8_general_ci

init-connect='SET NAMES utf8'

[2] 建立資料庫

CREATE DATABASE `dbname` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

另記: 查看資料庫使用之語系設定

show variables like '%character%';

ref: http://blog.pixnet.net/post/origin2/1295540