¡Ø ±¤°í¼º±ÛÀº »çÀü µ¿ÀÇ ¾øÀÌ »èÁ¦ ÇÕ´Ï´Ù.
  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

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


2. show variables like 'char%'; ÀÔ·Â

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)


 4-3 table »ó¼¼ ³»¿ë
mysql> use mysqlmysql> SHOW FULL COLUMNS FROM db;+-----------------------+---------------+-----------------+------+-----+---------+-------+---------------------------------+---------+| Field                 | Type          | Collation       | Null | Key | Default | Extra | Privileges                      | Comment |+-----------------------+---------------+-----------------+------+-----+---------+-------+---------------------------------+---------+| Host                  | char(60)      | utf8_bin        | NO   | PRI |         |       | select,insert,update,references |         || Db                    | char(64)      | utf8_bin        | NO   | PRI |         |       | select,insert,update,references |         || User                  | char(16)      | utf8_bin        | NO   | PRI |         |       | select,insert,update,references |         || Select_priv           | enum('N','Y') | utf8_general_ci | NO   |     | N       |       | select,insert,update,references |         || Insert_priv           | enum('N','Y') | utf8_general_ci | NO   |     | N       |       | select,insert,update,references |         || Update_priv           | enum('N','Y') | utf8_general_ci | NO   |     | N       |       | select,insert,update,references |         || Delete_priv           | enum('N','Y') | utf8_general_ci | NO   |     | N       |       | select,insert,update,references |    | Trigger_priv          | enum('N','Y') | utf8_general_ci | NO   |     | N       |       | select,insert,update,references |         |+-----------------------+---------------+-----------------+------+-----+---------+-------+---------------------------------+---------+22 rows 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-º¯°æ [²ÉÀÌ ÇÇ´Â ½Ã±â´Â ²É¸¶´Ù ´Ù¸£´Ù.] 

¸Þ¸ð³²±â±â ÇÑ±Û 150ÀÚ ¿µ¹®300ÀÚ À̳»
ÀÛ¼ºÀÚ         Æнº¿öµå                ÇöÀç  0 byte
[°ü·Ã±Û] ¾øÀ½ ÀÛ¼ºÀϽà : 2020-07-01 11:19:09
Copyright(c) 2003 xirom all right reserved vol.3
Contact xirom@xirom.net form more information