1: 2010-01-09 (土) 14:41:15 admin  |
2: 2010-01-09 (土) 14:43:38 admin |
| | log-error=/var/log/mysqld.log | | log-error=/var/log/mysqld.log |
| | pid-file=/var/mysql/mysqld.pid | | pid-file=/var/mysql/mysqld.pid |
| | + | |
| | + | *** 一時的に文字コードを変更（変更中にデータベースを作成） [#hc3135f7] |
| | + | mysql> show variables like "char%"; |
| | + | +--------------------------+-----------------------------------------------+ |
| | + | | Variable_name | Value | |
| | + | +--------------------------+-----------------------------------------------+ |
| | + | | character_set_client | latin1 | |
| | + | | character_set_connection | latin1 | |
| | + | | character_set_database | latin1 | |
| | + | | character_set_filesystem | binary | |
| | + | | character_set_results | latin1 | |
| | + | | character_set_server | latin1 | |
| | + | | character_set_system | utf8 | |
| | + | | character_sets_dir | /usr/local/mysql-5.0.67/share/mysql/charsets/ | |
| | + | +--------------------------+-----------------------------------------------+ |
| | + | この場合は latin1 を utf8にする |
| | + | mysql> set character_set_client=utf8; |
| | + | mysql> set character_set_connection=utf8; |
| | + | mysql> set character_set_database=utf8; |
| | + | mysql> set character_set_results=utf8; |
| | + | mysql> set character_set_server=utf8; |
| | + | 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 | /usr/local/mysql-5.0.67/share/mysql/charsets/ | |
| | + | +--------------------------+-----------------------------------------------+ |
| | + | - このタイミングでデータベースを作成する |
