(InstantRails)MySQLで文字コードをUTF8にする
ググレば出てくるけど一応メモ^^
①InstantRailsのConfigure→MySQLからmy.iniを開いて以下追記。
default-character-set=utf8
character-set-server=utf8
②MySQLにてdatabaseを作成し、該当databaseにて以下実施
mysql> set names utf8;
mysql> status; -------------- mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32) Connection id: 1 Current database: authtest2 Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 5.0.27-community Protocol version: 10 Connection: localhost via TCP/IP Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 TCP port: 3306 Uptime: 3 min 38 sec Threads: 1 Questions: 25 Slow queries: 0 Opens: 13 Flush tables: 1 Open tables: 7 Queries per second avg: 0.115 -------------- mysql> show variables like "char%"; +--------------------------+--------------------------------------------+ | 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 | C:\apps\INSTAN~1.0-W\mysql\share\charsets\ | +--------------------------+--------------------------------------------+ 8 rows in set (0.00 sec)