Mysql 자료실
Vote Reply Modify Delete Forward Prev Next List

  작성자   : 조성환 [ ladmin ] 추천: 1302, 수정: 2, 조회: 3850, 줄수: 73, 분류: Etc.
database character_set 확인하기

[sol40:/apache/bin] #   mysql -uroot -p******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 16 to server version: 5.0.27

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
mysql> show databases ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| db_zb4             |
| db_zb5             |
| mysql              |
| test               |
+--------------------+
5 rows in set (0.00 sec)

mysql>


mysql> use database db_zb5 ;


mysql> show variables like 'c%' ;

+--------------------------+----------------------------------------+
| Variable_name            | Value                                  |
+--------------------------+----------------------------------------+
| character_set_client     | euckr                                  |
| character_set_connection | euckr                                  |
| character_set_database   | euckr                                  |
| character_set_filesystem | binary                                 |
| character_set_results    | euckr                                  |
| character_set_server     | euckr                                  |
| character_set_system     | utf8                                   |
| character_sets_dir       | /usr/local/mysql/share/mysql/charsets/ |
| collation_connection     | euckr_korean_ci                        |
| collation_database       | euckr_korean_ci                        |
| collation_server         | euckr_korean_ci                        |
| completion_type          | 0                                      |
| concurrent_insert        | 1                                      |
| connect_timeout          | 5                                      |
+--------------------------+----------------------------------------+
14 rows in set (0.00 sec)



OR



mysql> show variables like 'char%';
+--------------------------+----------------------------------------+
| Variable_name            | Value                                  |
+--------------------------+----------------------------------------+
| character_set_client     | latin1                                 |
| character_set_connection | latin1                                 |
| character_set_database   | latin1                                 |
| character_set_filesystem | binary                                 |
| character_set_results    | latin1                                 |
| character_set_server     | latin1                                 |
| character_set_system     | utf8                                   |
| character_sets_dir       | /usr/local/mysql/share/mysql/charsets/ |
+--------------------------+----------------------------------------+
8 rows in set (0.00 sec)




이전: 스크립트로 mysql 백업이 안될때 확인사항 (쉘 지정, lib 패스 지정)
다음: MySQL 서버 기초 (강추)
2009/09/04(04:22) from 59.30.129.78
CrazyWWWBoard 2000

Vote Reply Modify Delete Forward Prev Next List
(c) Nobreak Technologies, Inc.