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 (¾®À]