MySQL CharacterSet º¯°æ | ¹øÈ£ : 540 ¹ø±Û Á¶È¸ : 599 ȸ |
MySQLÀÇ °æ¿ì ÃÖÃÊ ¼³Ä¡½Ã Latin1·Î ¼³Ä¡°¡ µÇ¾î ÀÖ´Ù. ±×·¡¼ ÇѱÛÀÌ Æ÷ÇÔµÈ Äõ¸®¸¦ ³Ö¾úÀ» °æ¿ì ÇѱÛÀÌ ±úÁ®¼ À¥ÆäÀÌÁö¿¡ Ç¥½Ã°¡ µÈ´Ù. ÀÌ ¶§ È®ÀÎ/º¯°æ¹ýÀº ´ÙÀ½°ú °°´Ù
È®ÀÎ
1. \s ¶Ç´Â status ÀÔ·Â
mysql> \s
--------------
mysql Ver 14.14 Distrib 5.1.73, for ibm-aix5.1.0.0 (powerpc) using readline 5.1
Connection id: 36
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.73 MySQL Community Server (GPL)
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: 14 hours 12 min 3 sec
Threads: 1 Questions: 2248 Slow queries: 0 Opens: 1027 Flush tables: 2 Open tables: 64 Queries per second avg:
0.43
--------------
mysql> show variables like 'char%';
+--------------------------+-------------------------------------+
| Variable_name | Value |
+--------------------------+-------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+-------------------------------------+
8 rows in set (0.00 sec)
3. db.opt ÆÄÀÏ È®ÀÎ
vi /usr/local/mysql/data/dbtest/db.opt
default-character-set=utf8
default-collation=utf8_general_ci
db¿¡ ¼³Á¤µÈ ³»¿ë È®ÀÎ °¡´É
4. Schema Á¶È¸
4-1 database ¼³Á¤ ³»¿ë È®ÀÎ
mysql> SELECT default_character_set_name FROM information_schema.SCHEMATA S
-> WHERE schema_name = "mysql";
+----------------------------+
| default_character_set_name |
+----------------------------+
| utf8 |
+----------------------------+
1 row in set (0.00 sec)
4-2 table ¼³Á¤ ³»¿ë È®ÀÎ
mysql> SELECT CCSA.character_set_name FROM information_schema.`TABLES` T,
-> information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA
WHERE CCSA.collation_name = T.table_collation
-> WHERE CCSA.collation_name = T.table_collation
-> AND T.table_schema = "mysql"
-> AND T.table_name = "db";
+--------------------+
| character_set_name |
+--------------------+
| utf8 |
+--------------------+
1 row in set (0.00 sec)
º¯°æ
1. ¸í·É¾î¸¦ ÀÌ¿ëÇÑ º¯°æ¹ý(mysql Àç½ÃÀ۽à ÃʱâȵÊ)
mysql> SET character_set_client = utf8;
mysql> SET character_set_results = utf8;
mysql> SET character_set_connection = utf8;
mysql> ALTER DATABASE DB¸í DEFAULT CHARACTER SET utf8;
mysql> commit;
commit ¸í·É¾î´Â ÇÏÀ§ Å×ÀÌºí¿¡ Àû¿ëÇÏ´Â ¸í·É¾î
2. my.cnf¿¡ Àû¿ëÇÏ´Â ¹æ¹ý(mysql Àç±âµ¿ ÇÊ¿ä)
[mysql]
default-character-set=utf8
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
character-set-client-handshake=FALSE
init_connect=SET collation_connection = utf8_general_ci
init_connect=SET NAMES utf8
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci
old_passwords=1
[client]
default-character-set=utf8
[mysqldump]
default-character-set=utf8
my.cnf ÆÄÀÏ¿¡ À§ ³»¿ëÀ» ³Ö°í mysqlÀ» Àç±âµ¿
»ý¼º
1. µ¥ÀÌŸ º£À̽º »ý¼º : utf8
CREATE DATABASE DB¸í DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;Ãâó: https://dupont3031.tistory.com/entry/MySQL-CharacterSet-º¯°æ [²ÉÀÌ ÇÇ´Â ½Ã±â´Â ²É¸¶´Ù ´Ù¸£´Ù.]
ÀÌ Àü ±Û | Centos6, 7 ¹öÀü ¾ð¾î¼Â º¯°æ |
´Ù À½ ±Û | PHP + MySQL Æ®·£Àè¼Ç ¿¹Á¦ |
[°ü·Ã±Û] | ¾øÀ½ | ÀÛ¼ºÀϽà : 2020-07-01 11:19:09 |
Copyright(c) 2003 xirom all right reserved vol.3 Contact xirom@xirom.net form more information |