page_adsence

2010年11月23日火曜日

MySQLで文字コード確認

メモ。
文字コードの確認方法は以下の通り。
> status
--------------
mysql  Ver 14.14 Distrib 5.1.50, for redhat-linux-gnu (i686) using readline 5.1

Connection id:          2848
Current database:       brooklyn
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.1.50 MySQL Community Server (GPL) by Utter Ramblings
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 119 days 2 hours 25 min 24 sec

Threads: 1  Questions: 20732  Slow queries: 0  Opens: 184  Flush tables: 1  Open tables: 10  Queries per second avg: 0.2
--------------