mysql:12373
From: Yasufumi Kinoshita <Yasufumi Kinoshita <kinoshita.yasufumi@xxxxxxxxxx>>
Date: Mon, 07 Nov 2005 20:17:00 +0900
Subject: [mysql 12373] Re: MySQL ÆüËܸìÌäÂêÅǤ½Ð¤·¶ÛµÞ¥ª¥Õ²ñ - ¤Þ¤È¤á
ÌÚ²¼¤Ç¤¹¡£ ¼è¤êÅ»¤á¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£ > c) Unicode -> JIS·Ïʸ»ú¥³¡¼¥É¤Ø¤ÎÊÑ´¹ > http://dev.mysql.com/doc/refman/4.1/ja/charset-cp932.html > ¤Îɽ¤Ë¤¢¤ë¤è¤¦¤Ë¡¢Unicode¤«¤écp932¡¢sjis¤Ë¤½¤ì¤¾¤ìÊÑ´¹¤¹¤ëºÝ¤Ë¡¢ > °ìÊý¤Ç¤ÏÊÑ´¹À褬³ä¤êÅö¤Æ¤é¤ì¤Æ¤¤¤ë¤¬¡¢¤â¤¦°ìÊý¤Ç¤ÏÊÑ´¹À褬 > ³ä¤êÅö¤Æ¤é¤ì¤Æ¤¤¤Ê¤¤¡Ê'3F' = '?' ¤¬³ä¤êÅö¤Æ¤é¤ì¤Æ¤¤¤ë¡Ëʸ»ú¤¬¤¢¤ë > ¡Êeucjpms¡¢ujis¤Ë¤Ä¤¤¤Æ¤âƱÍÍ¡Ë¡£¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¦¤Çʸ»ú¥³¡¼¥ÉÊÑ´¹¤¬ > ȯÀ¸¤¹¤ëºÝ¤Ë¡¢DB¦¤ÈƱ°ì¤Î¥¥ã¥é¥¯¥¿¡¼¥»¥Ã¥È¤ò»ØÄꤷ¤Ê¤¤¤È > ¥Ç¡¼¥¿Ç˲õ¤¬È¯À¸¤¹¤ë¾ì¹ç¤¬¤¢¤ë¡£ > > *¾åµ¤Îɽ¤Ë¤ª¤¤¤ÆUnicode¤«¤é¤ÎÊÑ´¹À褬³ä¤êÅö¤Æ¤é¤ì¤Æ¤¤¤Ê¤¤ > ʸ»ú¤Ë¤Ä¤¤¤Æ¡¢Â¾¤Î¥¥ã¥é¥¯¥¿¡¼¥»¥Ã¥È¤Ç³ä¤êÅö¤Æ¤é¤ì¤Æ¤¤¤ë¤â¤Î > ¤Ë¤Ä¤¤¤Æ¤ÏƱ°ì¤Îʸ»ú¤ò³ä¤êÅö¤Æ¤ÆÍߤ·¤¤¡£ > > # ÌÚ²¼¤µ¤ó¡¢¤³¤ÎÅÀ¤Ë¤Ä¤¤¤Æ¤Ï»ä¤Ê¤ê¤Î²ò¼á¤Ç½ñ¤¤¤Æ¤¢¤ê¤Þ¤¹¡£ > # ¸í¤ê¤¬¤¢¤ì¤Ð¤´»ØŦ¤ª´ê¤¤¤·¤Þ¤¹¡£ ²ò¼á¤ÏÁ´¤¯¤½¤ÎÄ̤ê¤Ç¤¹¡£¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£ ¤·¤«¤·¡¢¥Þ¥Ë¥å¥¢¥ë¤Î http://dev.mysql.com/doc/refman/4.1/ja/charset-cp932.html ¤Î²¼¤Îɽ¤À¤±¤Ç¤Ï¤ê¤Þ¤»¤ó¤Î¤Ç¡¢Ê䤵¤»¤Æ¤¤¤¿¤À¤¤Þ¤¹¡£ <¥·¥Õ¥ÈJIS:sjis,cp932> Á°½Ò¤Îɽ¤Ç¤¢¤²¤é¤ì¤¿ucs2¤Î¥³¡¼¥É¥Ý¥¤¥ó¥È¤Î¾¤Ë¡¢ ucs2 | sjis | cp932 -----------------------+-------+------- 00A5 (Ⱦ³Ñ¤Î¡ï¢¨) | 3F | 3F ¢¨Â¾¤Î¥½¥Õ¥È¤Ç¤ÎÊÑ´¹¤Ë¤è¤Ã¤Æ¤Ï¥·¥Õ¥ÈJIS¤Î "5C (¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥å)" ¤¬ ¤³¤Îʸ»ú¤Ë¤Ê¤ë¤³¤È¤âͤêÆÀ¤ë¤Î¤Ç¡¢Î¾Êý¤È¤â "5C" ¤Ë¤¹¤ë¡£ <ÆüËܸìEUC:ujis,eucjpms> Á°½Ò¤Îɽ¤Ç¤¢¤²¤é¤ì¤¿ucs2¤Î¥³¡¼¥É¥Ý¥¤¥ó¥È¤Î¾¤Ë¡¢ ucs2 | ujis | eucjpms -----------------------+---------------------+--------- 00A5 (Ⱦ³Ñ¤Î¡ï¢¨) | 8E5C5C¡Ê²½¤±¤Þ¤·¤¿¡Ë| 3F 00A6 (Ⱦ³Ñ¤Îüü) | 8FA2C3 | 3F FFE4 (Á´³Ñ¤Îüü) | 3F | 8FA2C3 ¢¨¥·¥Õ¥ÈJIS¤ÈƱÍÍ¡¢Î¾Êý¤È¤â "5C" ¤Ë¤¹¤ë¡£ ¿ʬ¤³¤ì¤ÇÁ´Éô¤À¤È»×¤¤¤Þ¤¹¡£ -- ÌÚ²¼ Ì÷ʸ e-mail: kinoshita.yasufumi@xxxxxxxxxx
12372 2005-11-07 18:16 ["Shuichi Tamagawa" <] MySQL ÆüËܸìÌäÂêÅǤ½Ð¤·¶ÛµÞ¥ª¥Õ²ñ - ¤Þ¤È¤á -> 12373 2005-11-07 20:17 ¨²[Yasufumi Kinoshita <] 12374 2005-11-07 21:21 ¨¨±["Shuichi Tamagawa" <] 12391 2005-11-08 15:59 ¨¡¡¨±[Yasufumi Kinoshita <] 12400 2005-11-08 20:50 ¨¡¡¡¡¨±["Shuichi Tamagawa" <] 12402 2005-11-08 21:14 ¨¡¡¡¡¡¡¨±[Hirofumi Fujiwara <f] 12412 2005-11-09 10:21 ¨¡¡¡¡¡¡¡¡¨²[Hiro Yoshioka <hyosh] 12413 2005-11-09 10:28 ¨¡¡¡¡¡¡¡¡¨¨±[<takeshi@xxxxxxxxxx>] 12414 2005-11-09 10:38 ¨¡¡¡¡¡¡¡¡¨¡¡¨±[Hiro Yoshioka <hyosh] 12415 2005-11-09 11:56 ¨¡¡¡¡¡¡¡¡¨¡¡¡¡¨±[<takeshi@xxxxxxxxxx>] 12416 2005-11-09 18:43 ¨¡¡¡¡¡¡¡¡¨¡¡¡¡¡¡¨±[Hiro Yoshioka <hyosh] 12428 2005-11-10 14:12 ¨¡¡¡¡¡¡¡¡¨¡¡¡¡¡¡¡¡¨±[<takeshi@xxxxxxxxxx>] 12520 2005-11-30 10:49 ¨¡¡¡¡¡¡¡¡¨²[Tetsuro IKEDA <tetsu] 12525 2005-12-01 13:26 ¨¡¡¡¡¡¡¡¡¨¨±[Hirofumi Fujiwara <f] 12598 2005-12-21 08:20 ¨¡¡¡¡¡¡¡¡¨±[Tetsuro IKEDA <tetsu] ¥á¥¿¥Ç¡¼¥¿¤Ë2¥Ð¥¤¥ÈÌܤ¬`(60)¤Î´Á»ú¤ò»ÈÍѤ¹¤ë¾ì¹ç¤ÎÉÔ¶ñ¹ç¤Î·ï 12599 2005-12-21 12:43 ¨¡¡¡¡¡¡¡¡¡¡¨±[Hirofumi Fujiwara <f] 12377 2005-11-07 23:55 ¨²[Tadashi Jokagi <ml@x] 12399 2005-11-08 20:43 ¨¨±["Shuichi Tamagawa" <] 12378 2005-11-08 00:11 ¨²[<takeshi@xxxxxxxxxx>] 12380 2005-11-08 09:27 ¨¨²["Shuichi Tamagawa" <] 12381 2005-11-08 09:36 ¨¨¨±[<takeshi@xxxxxxxxxx>] 12403 2005-11-08 21:22 ¨¨¡¡¨±[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm] 12405 2005-11-08 21:42 ¨¨¡¡¡¡¨±[<takeshi@xxxxxxxxxx>] 12397 2005-11-08 20:29 ¨¨±["Shuichi Tamagawa" <] 12401 2005-11-08 21:11 ¨¡¡¨±[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm] 12404 2005-11-08 21:27 ¨¡¡¡¡¨²[Hirofumi Fujiwara <f] 12406 2005-11-08 21:52 ¨¡¡¡¡¨²[<takeshi@xxxxxxxxxx>] 12417 2005-11-09 19:46 ¨¡¡¡¡¨¨²[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm] 12418 2005-11-09 20:15 ¨¡¡¡¡¨¨¨±[<takeshi@xxxxxxxxxx>] 12419 2005-11-10 11:13 ¨¡¡¡¡¨¨¡¡¨±[Yasufumi Kinoshita <] 12425 2005-11-10 13:21 ¨¡¡¡¡¨¨¡¡¡¡¨²[<takeshi@xxxxxxxxxx>] 12429 2005-11-10 14:47 ¨¡¡¡¡¨¨¡¡¡¡¨±[MORIYAMA Masayuki <m] 12432 2005-11-10 20:15 ¨¡¡¡¡¨¨¡¡¡¡¡¡¨±[Yasufumi Kinoshita <] 12433 2005-11-11 00:37 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¨±[MORIYAMA Masayuki <m] 12435 2005-11-11 19:54 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¨±[Yasufumi Kinoshita <] Re: MySQL ÆüËܸìÌäÂêÅǤ½Ð¤·¶ÛµÞ¥ª¥Õ²ñ -¤Þ¤È¤á¡¡¡Úc°ÆÀ°Íý¡Û 12440 2005-11-12 11:48 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨²[MORIYAMA Masayuki <m] 12441 2005-11-12 12:52 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨¨±[MORIYAMA Masayuki <m] 12442 2005-11-13 14:06 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨²[MORIYAMA Masayuki <m] 12452 2005-11-14 11:20 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨¨±[MORIYAMA Masayuki <m] 12453 2005-11-14 12:51 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨¡¡¨²["Shuichi Tamagawa" <] 12462 2005-11-16 11:18 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨¡¡¨¨±[MORIYAMA Masayuki <m] 12464 2005-11-16 15:05 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨¡¡¨¡¡¨±["Shuichi Tamagawa" <] 12454 2005-11-14 15:27 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨¡¡¨±[Yasufumi Kinoshita <] Re: MySQL ÆüËܸìÌäÂêÅǤ½Ð¤·¶ÛµÞ¥ª¥Õ²ñ -¤Þ¤È¤á¡¡¡Úc°ÆÀ°Íý¡Û³§ÍͤΤ´°Õ¸«¤ò¤ª´ê¤¤¤·¤Þ¤¹¡£ 12461 2005-11-16 03:10 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨¡¡¡¡¨²[MORIYAMA Masayuki <m] 12463 2005-11-16 15:00 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨¡¡¡¡¨±["Shuichi Tamagawa" <] 12466 2005-11-17 11:34 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨¡¡¡¡¡¡¨±[Yasufumi Kinoshita <] 12468 2005-11-17 15:46 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨¡¡¡¡¡¡¡¡¨±["Shuichi Tamagawa" <] 12470 2005-11-17 16:36 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨¡¡¡¡¡¡¡¡¡¡¨±[Yasufumi Kinoshita <] 12473 2005-11-17 17:48 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨¡¡¡¡¡¡¡¡¡¡¡¡¨±["Shuichi Tamagawa" <] 12448 2005-11-14 09:14 ¨¡¡¡¡¨¨¡¡¡¡¡¡¡¡¡¡¡¡¨±["Shuichi Tamagawa" <] 12426 2005-11-10 13:57 ¨¡¡¡¡¨¨±["Shuichi Tamagawa" <] 12427 2005-11-10 14:02 ¨¡¡¡¡¨¡¡¨±[<takeshi@xxxxxxxxxx>] 12411 2005-11-09 09:15 ¨¡¡¡¡¨±["Shuichi Tamagawa" <] 12475 2005-11-18 09:48 ¨±["Shuichi Tamagawa" <] 12476 2005-11-18 09:54 ¡¡¨²["Ryuichiro Munechika] 12613 2005-12-28 16:59 ¡¡¨±["Shuichi Tamagawa" <]