답변 1개
11년 전
아래와 같이 mysql 을 쉘로 접속하신후 DB, Client 의 charset 이 utf8 로 설정되어 있는지 확인하여 주십시오.
Copy
$ mysql -u유저명 -p패스워드 디비명
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2127
Server version: 5.1.30-log Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> \s
--------------
mysql Ver 14.14 Distrib 5.1.30, for pc-linux-gnu (i686) using readline 5.1
Connection id: 2127
Current database: sir
Current user: sir@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.30-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 2 days 8 hours 38 min 55 sec
Threads: 1 Questions: 22833 Slow queries: 3 Opens: 8731 Flush tables: 1 Open tables: 256 Queries per second avg: 0.111
--------------
답변을 작성하려면 로그인이 필요합니다.
