[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:13670

From: Yasufumi Kinoshita <Yasufumi Kinoshita <kinoshita.yasufumi@xxxxxxxxxx>>
Date: Mon, 15 Jan 2007 12:25:39 +0900
Subject: [mysql 13670] Re: UTF8 4¥Ð¥¤¥Èʸ»ú

ÌÚ²¼¤Ç¤¹¡£

¤³¤ÎFeature request¤Ç¤·¤ç¤¦¤«¡©
http://bugs.mysql.com/bug.php?id=14052

°ìºòǯ¤«¤éÊüÃÖ¤µ¤ì¤Æ¤ë¤è¤¦¤Ç¤¹¤Í¡£¡£
MySQL¤Ç¤Ï¸½ºßÆâÉô¤Ç¤ÏUCS-2(£±Ê¸»ú£²¥Ð¥¤¥È¸ÇÄêĹ)¤Ê¤Î¤Ç¡¢
UTF-8¤Ç¤Ï£³¥Ð¥¤¥Èʸ»ú¤Þ¤Ç¤ÎÈϰϤ·¤«¡Êʸ»ú¤È¤·¤Æ¡Ë°·¤¨¤Ê¤¤¤Î¤Ç¤¹¤Í¡£

¤³¤Î¥Ú¡¼¥¸¤ÎSuggested fix¤Î¤è¤¦¤Ë¡¢ÆâÉôɽ¸½¤ò
¥µ¥í¥²¡¼¥È¥Ú¥¢¤ò¥µ¥Ý¡¼¥È¤¹¤ë¤è¤¦¤Ë¤¹¤ëUCS-2( = UTF16)¤Ë
³ÈÄ¥¤¹¤ì¤ÐÄÔêí¤¬¹ç¤¦¤È»×¤¦¤Î¤Ç¤¹¤¬¡¢¤½¤¦¤¹¤ë¤È¸ÇÄêŤÀ¤Ã¤¿Ê¸»ú¤ÎÆâÉôɽ¸½¤¬
£±Ê¸»ú¤¬£²¥Ð¥¤¥È¤«£´¥Ð¥¤¥È¤Î²ÄÊÑĹ¤È¤Ê¤Ã¤Æ¤·¤Þ¤¦¤ï¤±¤Ç¡¢ÌÌÅݤ½¤¦¤Ç¤¹¡£¡£
ÁêÅö¥¢¥Ô¡¼¥ë¤·¤Ê¤¤¤ÈɬÍ×À­¤òÍý²ò¤·¤Æ¤â¤é¤¨¤Ê¤¤¤«¤â¤·¤ì¤Þ¤»¤ó¤Í¡£

#¤µ¤Æ¡¢º¤¤ê¤Þ¤·¤¿¤Í¡Ä
#¾¯¤·Â¾ÎÏËÜ´ê^^;

#UTF-8¤Î4¥Ð¥¤¥È°Ê¾åʸ»ú¤¬ÆÃÄê¤Îʸ»ú¡Ê¡Ö?¡×¤È¤«¡Ë¤ËÃÖ¤­´¹¤¨¤é¤ì¤Æ
#¤·¤Þ¤¦¤è¤¦¤Ê±þµÞ½èÃ֤ʤéÊѹ¹²Õ½ê¤¬¾¯¤Ê¤½¤¦¤Ê¤Î¤Ç¤¹¤°¤Ç¤­¤½¤¦¤Ç¤¹¤¬¡¢¡¢
#¤½¤ì¤Ç¤Ï°ÕÌ£¤Ê¤¤¤Ç¤¹¤è¤Í¡©

> ¤È¤ß¤¿¤Ç¤¹¡£
> 
> Windows Vista ¤Ç JISÂè»°/»Í¿å½à¤¬¥µ¥Ý¡¼¥È¤µ¤ì¤ë¤È¡¢UTF8 ¤Î 4¥Ð¥¤¥Èʸ»ú
> ¤¬»ÈÍѤµ¤ì¤ë²ÄǽÀ­¤¬¤¢¤ë¤Î¤Ç¤¹¤¬¡¢¸½¾õ¤Î MySQL ¤Ç¤Ï UTF8 ¤Ï 3¥Ð¥¤¥Èʸ
> »ú¤Þ¤Ç¤·¤«¥µ¥Ý¡¼¥È¤·¤Æ¤¤¤Ê¤¤¤è¤¦¤Ç¤¹¡£
> 
> MySQL ¤Ë 4¥Ð¥¤¥Èʸ»ú¤ò´Þ¤à UTF8 ʸ»úÎó¤ò INSERT/UPDATE ¤·¤è¤¦¤È¤¹¤ë¤È¡¢
> Îã¤Ë¤è¤Ã¤Æ¤½¤Îʸ»ú°Ê¹ß¤¬¤¹¤Ù¤Æ¾Ã¤¨¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
> 
> MySQL ¤Î UTF8 4¥Ð¥¤¥Èʸ»ú¤Î¥µ¥Ý¡¼¥ÈͽÄê¤È¤«¤Ê¤¤¤ó¤Ç¤·¤ç¤¦¤«¡Ä¡£
> 
> # ¤ä¤Ï¤ê¡¢ASCII ¤È¤« BINARY ¤ò»ÈÍѤ·¤Æ¡¢MySQL ¤Ë¤Ïʸ»ú¥³¡¼¥É¤Ë´Ø¤¹¤ë;
> # ·×¤Ê½èÍý¤ò¤µ¤»¤Ê¤¤¤è¤¦¤Ë¤¹¤ë¤Î¤¬Îɤ¤¤Î¤«¤Ê¤¡¡Ä¡£
> 



[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

     13666 2007-01-12 22:32 [¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm] UTF8 4¥Ð¥¤¥Èʸ»ú                        
     13667 2007-01-13 01:48 ¨²[SOUMA Yutaka <holon@]                                       
     13678 2007-01-15 18:16 ¨­¨±[MORIYAMA Masayuki <m]                                     
->   13670 2007-01-15 12:25 ¨±[Yasufumi Kinoshita <]                                       
     13671 2007-01-15 13:42 ¡¡¨²[<ymatsunobu@xxxxxxxx] Re: UTF8 4$B%P%$%HJ8;z(B          
     13679 2007-01-19 00:58 ¡¡¨­¨±[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm] Re: UTF8 4¥Ð¥¤¥Èʸ»ú              
     13692 2007-01-25 11:27 ¡¡¨±["OGAWA Motoyuki (¾®À]