mysql文字コード環境の調査方法

mysqladmin versionコマンド

# mysqladmin version
mysqladmin Ver 8.41 Distrib 4.1.7, for pc-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.1.7
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 min 31 sec

Threads: 1 Questions: 3 Slow queries: 0 Opens: 11 Flush tables: 1 Open tables: 0 Queries per second avg: 0.033

mysqlにログインしてstatusコマンド。

4.0系
mysql> status;
--------------
mysql Ver 12.22 Distrib 4.0.25, for pc-linux-gnu (i686)

Connection id: 18
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.25-Max
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: ujis
Server characterset: ujis
UNIX socket: /tmp/mysql.sock
Uptime: 7 min 31 sec

Threads: 1 Questions: 401 Slow queries: 0 Opens: 30 Flush tables: 1 Open tables: 24 Queries per second avg: 0.889

4.1系
mysql> status;
--------------
mysql Ver 14.7 Distrib 4.1.7, for pc-linux (i686)

Connection id: 9
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 4.1.7
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: ujis
Db characterset: ujis
Client characterset: ujis
Conn. characterset: ujis
UNIX socket: /tmp/mysql.sock
Uptime: 8 min 0 sec

Threads: 1 Questions: 656 Slow queries: 0 Opens: 25 Flush tables: 1 Open tables: 14 Queries per second avg: 1.367

5.0系
status;
--------------
mysql Ver 14.12 Distrib 5.0.22, for pc-linux-gnu (i686) using EditLine wrapper

Connection id: 9
Current database: information_schema
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.22
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: ujis
Db characterset: utf8
Client characterset: ujis
Conn. characterset: ujis
UNIX socket: /tmp/mysql.sock
Uptime: 10 min 54 sec

Threads: 1 Questions: 77 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 17 Queries per second avg: 0.118

また、show variablesコマンドも文字コードを含むmysql環境が解る。