「mysql覚書」の編集履歴（バックアップ）一覧はこちら

「mysql覚書」(2008/02/25 (月) 16:03:49) の最新版変更点

追加された行は緑色になります。

削除された行は赤色になります。

デフォルト
mysql> status
--------------
mysql  Ver 14.12 Distrib 5.0.45, for Win32 (ia32)
Server characterset:    sjis
Db     characterset:    sjis
Client characterset:    sjis
Conn.  characterset:    sjis

mysql> show variables like '%char%';
+--------------------------+------------------------------+
| Variable_name            | Value                        |
+--------------------------+------------------------------+
| character_set_client     | sjis                         |
| character_set_connection | sjis                         |
| character_set_database   | sjis                         |
| character_set_filesystem | binary                       |
| character_set_results    | sjis                         |
| character_set_server     | sjis                         |
| character_set_system     | utf8                         |
| character_sets_dir       | H:＼mysql＼share＼charsets＼ |
+--------------------------+------------------------------+

文字コードセット(ujis)
mysql> set names ujis;
mysql> status
Server characterset:    sjis
Db     characterset:    sjis
Client characterset:    ujis<--変化
Conn.  characterset:    ujis<--変化

mysql> show variables like '%char%';
+--------------------------+--------------------------+
| Variable_name            | Value                    |
+--------------------------+--------------------------+
| character_set_client     | ujis                     |<--変化
| character_set_connection | ujis                     |<--変化
| character_set_database   | sjis                     |
| character_set_filesystem | binary                   |
| character_set_results    | ujis                     |<--変化
| character_set_server     | sjis                     |
| character_set_system     | utf8                     |
| character_sets_dir       | H:\mysql\share\charsets\ |
+--------------------------+--------------------------+