4: 2009-06-11 (木) 21:34:25 iseki |
現: 2010-01-09 (土) 14:45:16 admin |
| - 移行先は utf8 | | - 移行先は utf8 |
| | | |
- | **** 移行先を UTF-8 にする [#u5d358e3] | + | **** [[移行先を UTF-8 にする>/MySQL/utf8]] [#u5d358e3] |
- | 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/ | | + | |
- | +--------------------------+-----------------------------------------------+ | + | |
- | | + | |
- | **** 作成時に 文字セットを指定可能 [#z5be219c] | + | |
- | mysql> create database db_name default character set utf8; | + | |
| | | |
| **** データベースのストアとリストア [#f598b57c] | | **** データベースのストアとリストア [#f598b57c] |