ÌÚ²¼¤Ç¤¹¡£

¤³¤Î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 ¤Ë¤Ïʸ»ú¥³¡¼¥É¤Ë´Ø¤¹¤ë;
> # ·×¤Ê½èÍý¤ò¤µ¤»¤Ê¤¤¤è¤¦¤Ë¤¹¤ë¤Î¤¬Îɤ¤¤Î¤«¤Ê¤¡¡Ä¡£
>