作者dryman (dryman)
看板Ruby
标题Re: [RoR ] 中文乱码
时间Tue Jul 28 11:42:05 2009
自问自答
虽然我想大部分看板的人都会这种简单的操作
但我还是写一下好了:p
先shotdown mysql
到mysql安装好的目录中找support-files/my-small.cnf (M$的好像是my-small.ini)
mac的目录在：/usr/local/mysql/support-files/my-small.cnf
（在finder的工具列中找[前往][前往档案夹] 就可以进入隐藏的目录）
把这档案复制一份到/etc底下，更名为my.cnf
用文字编辑器打开它，并加上几行：
[client]底下多加
default-character-set=utf8
[mysqld]底下多加
init-connect = 'SET NAMES utf8'
character-set-server = utf8
collation-server = utf8_general_ci
default-character-set = utf8
然後再重新打开mysql server就成功了
可以在mysql下检查：
mysql> show variables like 'character%';
+--------------------------+--------------------------------------------------
| Variable_name | Value
+--------------------------+--------------------------------------------------
| character_set_client | utf8
| character_set_connection | utf8
| character_set_database | utf8
| character_set_filesystem | binary
| character_set_results | utf8
| character_set_server | utf8
| character_set_system | utf8
| character_sets_dir | /usr/local/mysql-5.1.36-osx10.5-x86/share/charsets
+--------------------------+---------------------------------------------------
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 61.224.55.12