mysql characterset 변경

이 밑에 것이 더 확실함.

http://ssppmm.tistory.com/1595

mysql> set character_set_client=utf8;

mysql> set character_set_results=utf8;

mysql> set character_set_connection=utf8;

mysql> set character_set_server=utf8;

mysql> alter database test default character set utf8;

mysql> commit;

mysql> status

--------------

/usr/bin/mysql  Ver 14.14 Distrib 5.1.61, for redhat-linux-gnu (x86_64) using readline 5.1

Connection id: 8

Current database: test

Current user: root@localhost

SSL: Not in use

Current pager: stdout

Using outfile: ''

Using delimiter: ;

Server version: 5.1.61 Source distribution

Protocol version: 10

Connection: Localhost via UNIX socket

Server characterset: utf8

Db     characterset: utf8

Client characterset: utf8

Conn.  characterset: utf8

UNIX socket: /var/lib/mysql/mysql.sock

Uptime: 19 min 39 sec

Threads: 1  Questions: 87  Slow queries: 0  Opens: 31  Flush tables: 1  Open tables: 24  Queries per second avg: 0.73

--------------

된다.

http://kch1183.blog.me/50100189373