¸¶½ºÅÍÆ÷À¯(Master4U)
Monday, 17 of January
 

·Î±×ÀÎ Category
UFT8 ¿¡¼­ euckr·Î º¯°æ ¹æ¹ý
°ü¸®ÀÚ  2008-02-10 12:11:46 Hit:3747
¸µÅ© #1: http://blog.naver.com/neoi?Redirect=Log&logNo=120012933124

[Æß] [mysql]uft8¿¡¼­ euckr·Î º¯°æ ¹æ¹ý

mysql

2005/05/10 00:05

Ãâó ºí·Î±× > ÀØ¾î ¹ö¸®°í ÇÊ¿ä ÇÒ ¶§ ãÀÚ
¿øº» http://blog.naver.com/chang0c/120010955186

ÀÌ¹Ì ÀÔ·ÂµÈ µ¥ÀÌŸ´Â ¹é¾÷ ÈÄ ´Ù½Ã ³Ö¾î ÁÖ¾î¾ß ÇÑ´Ù.

 

¹æ¹ý 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 À» »ç¿ëÇÏ¿© ÇØ°áÇÒ ¼ö ÀÖÁö¸¸ ÀÌ·¸°Ô ÇÏ¸é ¿µ¹®ÀÚÀÇ ´ë¼Ò¹®ÀÚ°¡ ±¸ºÐµÇ¾î ¹ö¸³´Ï´Ù.

º»¹®Àμ⺻¹®¸ÞÀϹ߼Û
¡â characterset º¯°æ (DB»ý¼ºÇÒ¶§, º¯°æÇÒ¶§) [1]
¡ä MySQL 4.1.x ¹®ÀÚ¼Â, ÀÎÄÚµù, UTF-8
Copyright 1999-2025 Zeroboard / skin by ChanBi