mysql:11985
From: Masatugu Teshima <Masatugu Teshima <teshima@xxxxxxxxxx>>
Date: Mon, 22 Aug 2005 18:30:15 +0900
Subject: [mysql 11985] MySQL5 + MyODBC + Access 2000¤Ç°ìÉô¤ÎÆüËܸìʸ»ú¤¬ÅÐÏ¿¤Ç¤¤Ê¤¤¡£
¤Ï¤¸¤á¤Þ¤·¤Æ¡¢¼êÅç¤È¿½¤·¤Þ¤¹¡£ º£²ó¡¢MySQL5.0.09¡ÜMyODBC3.5.11-2¡ÜAccess2000¤Î´Ä¶¤Ç¡¢Access2000¥¢¥×¥ê¤Î °Ü¿¢¤ò¤ä¤ë¤³¤È¤Ë¤Ê¤ê¤Þ¤·¤¿¡£ ¤½¤³¤Ç¡¢Ê¸»ú²½¤±¤Ï»î¹Ôºø¸í¤·¤Æ²ò¾Ã¤·¤¿¤Î¤Ç¤¹¤¬¡¢°ìÉô¤Î¡Öɽ¡×¡Ö¥½¡×¤Ç½ª¤ï¤ë ʸ»úÎ󤬤¢¤ë¥ì¥³¡¼¥É¤¬°Ê²¼¤Î¥¨¥é¡¼¤ò½Ð¤·¤ÆÅÐÏ¿¤Ç¤¤Þ¤»¤ó¡£ Î㤨¤Ð¡¢¡Ö½¸·×ɽ¡×¤È¤«¤Ç¤¹¡£¡Ö½¸·×ɽ¡ÊÉôÌçÊ̡ˡפȤ«ÅÓÃ椢¤ë¤Î¤ÏÂç¾æÉפǤ¹¡£ ¡ÖODBC--¥ê¥ó¥¯¥Æ¡¼¥Ö¥ë 'xxxxxxxx'¤Ø¤ÎÁÞÆþ¤ß¼ºÇÔ¤·¤Þ¤·¤¿¡£¡× ʸ»ú¥³¡¼¥É¼þ¤ê¤¬²ø¤·¤¤¤È»×¤Ã¤Æ¡¢¤³¤ì¤é¤Îʸ»ú¥³¡¼¥É¤ò¸«¤Æ¤ß¤ë¤È ɽ:95 5C ¥½:83 5C ¤È¤Ê¤Ã¤Æ¤ª¤ê¡¢5C¤¬ºÇ¸å¤ËÍè¤Æ¤¤¤ë¤Î¤¬¸¶°ø¤«¤Ê¡©¤È»×¤Ã¤Æ¤¤¤Þ¤¹¡£ 5C¤ÏñÆȤǡ¢\¤Ç¤¹¤·¡¦¡¦¡¦ ¤³¤Îʸ»ú¤¬ÅÓÃæ¤Ë¤¢¤Ã¤Æ¤âÌäÂê¤Ê¤¤¤Î¤¬ÉԻ׵ĤǤ¹¤¬¡¦¡¦¡¦ ODBC¤ÎÀßÄê Initial Statement:set names sjis utf8¤â»î¤·¤Æ¤ß¤Þ¤·¤¿¤¬¤À¤á¤Ç¤·¤¿¡£ Return Matching rows ¤Ï¥Á¥§¥Ã¥¯¤·¤Æ¤¤¤Þ¤¹¡£ ¤½¤Î¾¤Ï¥Ç¥Õ¥©¥ë¥È¤Î¤Þ¤Þ¤Ç¤¹¡£ ¥Ç¡¼¥¿¥Ù¡¼¥¹Â¦ ʸ»ú¥³¡¼¥Ésjis¤Èutf8¤È¤â¤Ë¤À¤á¤Ç¤·¤¿¡£ ³§¤µ¤ó¤Ï¤³¤Î¤è¤¦¤Ê¸½¾Ý¤Ë¤¢¤ï¤ì¤¿¤³¤È¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡©
-> 11985 2005-08-22 18:30 [Masatugu Teshima <te] MySQL5 + MyODBC + Access 2000¤Ç°ìÉô¤ÎÆüËܸìʸ»ú¤¬ÅÐÏ¿¤Ç¤¤Ê¤¤¡£ 11986 2005-08-23 05:05 ¨²["KKuji_Y2a" <kkuji@x] 11987 2005-08-23 09:19 ¨¨±[Masatugu Teshima <te] 11989 2005-08-23 14:00 ¨¡¡¨±["KKuji_Y2a" <kkuji@x] 11990 2005-08-23 14:46 ¨¡¡¡¡¨±[Masatugu Teshima <te] 11991 2005-08-23 17:47 ¨¡¡¡¡¡¡¨±[Æâƣʹ²ð <naito@xxxx] 11992 2005-08-24 09:18 ¨¡¡¡¡¡¡¡¡¨±[Masatugu Teshima <te] 11994 2005-08-24 11:43 ¨¡¡¡¡¡¡¡¡¡¡¨²[<naito@xxxxxxxxxx> ] 11995 2005-08-24 13:47 ¨¡¡¡¡¡¡¡¡¡¡¨¨±[Topsystem ²¼ÃÏ <simo] 11996 2005-08-24 13:53 ¨¡¡¡¡¡¡¡¡¡¡¨²[Seiichi YANAI <yanai] 11997 2005-08-24 14:19 ¨¡¡¡¡¡¡¡¡¡¡¨±[Masatugu Teshima <te] 11998 2005-08-24 14:52 ¨¡¡¡¡¡¡¡¡¡¡¡¡¨²[SUGIMURA Takashi ¿ùÂ] 12002 2005-08-24 18:03 ¨¡¡¡¡¡¡¡¡¡¡¡¡¨¨±[Masatugu Teshima <te] 11999 2005-08-24 14:33 ¨¡¡¡¡¡¡¡¡¡¡¡¡¨±[Hirofumi Fujiwara <f] 12001 2005-08-24 18:02 ¨¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨±[Masatugu Teshima <te] 12008 2005-08-25 09:32 ¨±["Shuichi Tamagawa" <] 12009 2005-08-25 21:06 ¡¡¨²["S.Yamada" <proton@x] 12012 2005-08-26 16:08 ¡¡¨¨±[Masatugu Teshima <te] 12011 2005-08-26 16:06 ¡¡¨±[Masatugu Teshima <te]