[Æß] [mysql]uft8¿¡¼ euckr·Î º¯°æ ¹æ¹ýmysql
2005/05/10 00:05
http://blog.naver.com/neoi/120012834729
ÀÌ¹Ì ÀÔ·ÂµÈ µ¥ÀÌŸ´Â ¹é¾÷ ÈÄ ´Ù½Ã ³Ö¾î ÁÖ¾î¾ß ÇÑ´Ù.
¹æ¹ý 1
mysql> SET character_set_client = euckr; mysql> SET character_set_results = euckr; mysql> SET character_set_connection = euckr; mysql> ALTER DATABASE [DB¸í] DEFAULT CHARACTER SET euckr; commit;
¹æ¹ý 2
set names euckr;
Àúµµ ÀÌ ¹®Á¦ ¶§¹®¿¡ °ñÄ¡ ¾ÆÆÍ´ø ÀûÀÌ ÀÖ½À´Ï´Ù.
´Ü¼øÇÏ°Ô set names euckr À» ÇØÁÖ½Ã¸é µË´Ï´Ù.
ÀÌ ¸í·ÉÀº Server, Connection ÀÇ ¹®ÀÚ¼ÂÀ» euckr ·Î ¼³Á¤ÇÕ´Ï´Ù.
mysqld ÀÇ ½ÃÀۿɼÇÀ̳ª my.cnf ÀÇ [mysqld] ¼½¼Ç¿¡ default-character-set = euckr ¿É¼ÇÀ» ÁöÁ¤Çϸé Db, Client ÀÇ ¹®ÀÚ¼ÂÀÌ euckr·Î ¼³Á¤µË´Ï´Ù. mysql ÇÁ·Î±×·¥¿¡¼ \s ¸¦ ÇØº¸¸é È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù. set names ´ë½Å [mysql] ¼½¼Ç¿¡ default-character-set À» »ç¿ëÇÒ ¼ö Àִµ¥ ÀÌ·¸°Ô Çϸé 4.1.8¿¡¼´Â mysqladmin ÀÌ ÇØ´ç ¿É¼ÇÀ» ÀÌÇØÇÏÁö ¸øÇØ Á¦´ë·Î ½ÇÇàÀÌ ¾ÈµË´Ï´Ù. 4.1.9¿¡¼´Â mysqladmin ÇÁ·Î±×·¥µµ default-character-set ¿É¼ÇÀ» »ç¿ëÇÒ ¼ö ÀÖµµ·Ï º¯°æµÇ¾ú½À´Ï´Ù.
¹®Àڼ°ú °ü·ÃÇÏ¿© ÁÖÀÇÇÒ Á¡Àº ÀÏ´Ü latin1 µîÀÇ ´Ù¸¥ ¹®ÀÚ¼ÂÀ¸·Î ¼³Á¤µÈ Çʵ忡 µ¥ÀÌÅ͸¦ ÀÔ·ÂÇÑ ÈÄ alter ¸í·ÉÀ» ÅëÇØ ÇØ´ç ÇʵåÀÇ ¹®ÀÚ¼ÂÀ» euckr·Î ¼³Á¤ÇÏ¸é ¹«ÀÚºñÇÏ°Ô ±úÁø´Ù´Â °ÍÀÔ´Ï´Ù.
create table test (merong varchar(20) collate latin1_general_ci);
ÀÌ·¸°Ô ¸¸µé¾îÁø Å×ÀÌºí¿¡ ÇÑ±Û µ¥ÀÌÅ͸¦ ³ÖÀº ÈÄ Çʵ带 euckr ·Î º¯°æÇÏ·Á¸é ´ÙÀ½Ã³·³ ÇØ¾ß ÇÕ´Ï´Ù.
alter table test modify merong binary(100);
alter table test modify merong varchar(20) collate euckr_korean_ci;
binary ·Î ¹Ù²Ù¸é ¹®Àڼ Ư¼ºÀÌ »ç¶óÁö±â ¶§¹®¿¡ ÀÌ·± º¯È¯°úÁ¤À» °ÅÃÄ¾ß ÇÕ´Ï´Ù(¸Þ´º¾ó¿¡ ÀÇÇϸé). ±×³É ¹Ù²Ù¸é ¹®ÀÚµéÀÌ ¼Õ»óµË´Ï´Ù.
¹ÙÀ̳ʸ® ¹èÆ÷ÆÇ¿¡¼ ±âº»ÀûÀ¸·Î ¼³Á¤µÈ latin1 Àº Á¤·ÄÀ» À§ÇØ latin1_swedish_ci À» »ç¿ëÇϴµ¥ ÀÌ °æ¿ì 'ÀÌ' ¿Í 'ÀÎ'ÀÌ °°Àº ¹®ÀÚ·Î ÀνĵǴ ½ÄÀÌ¾î¼ unique ۸¦ ¼³Á¤Çϴµ¥ ¹®Á¦°¡ ¹ß»ýÇÕ´Ï´Ù. À̰ÍÀº latin1_bin µîÀÇ collation À» »ç¿ëÇÏ¿© ÇØ°áÇÒ ¼ö ÀÖÁö¸¸ ÀÌ·¸°Ô ÇÏ¸é ¿µ¹®ÀÚÀÇ ´ë¼Ò¹®ÀÚ°¡ ±¸ºÐµÇ¾î ¹ö¸³´Ï´Ù.
|