mysql:12001
From: Masatugu Teshima <Masatugu Teshima <teshima@xxxxxxxxxx>>
Date: Wed, 24 Aug 2005 18:02:05 +0900
Subject: [mysql 12001] Re: MySQL5 + MyODBC + Access 2000¤Ç°ìÉô¤ÎÆüËܸìʸ»ú¤¬ÅÐÏ¿¤Ç¤¤Ê¤¤¡£
Æ£¸¶ÍͤϤ¸¤á¤Þ¤·¤Æ ¼êÅç¤È¿½¤·¤Þ¤¹¡£ > ÌäÂ꤬ȯÀ¸¤¹¤ëSQLʸ¤½¤Î¤â¤Î(create table,insert)¤ò¶µ¤¨¤Æ¤â¤é¤¨¤Þ¤» > ¤ó¤Ç¤·¤ç¤¦¤«¡© ¼ÂºÝ¤Ë¼Â¸³¤·¤Æ¤ß¤¿¤¤¤â¤Î¤Ç¡£ ´Ä¶ Server Windows2000 + MySQL5.0.9 Client Windows XP + Access 2000 + MyODBC3.5.11-2 ¾åµ¤Î´Ä¶¤Ç Access 2000 ¤ËODBC¥ê¥ó¥¯¥Æ¡¼¥Ö¥ë¤òºîÀ®¤·¤Æ¡¢¤½¤Î¥Æ¡¼¥Ö¥ë¤òľÀܳ«¤¤¤Æ ¥Ç¡¼¥¿¤òÆþÎϤ·¤Æ»î¤·¤Æ¤¤¤Þ¤¹¡£ table¼«ÂΤϴÊñ¤Ê¤â¤Î¤Ç°Ê²¼¤Îʸ¤ÇºîÀ®¤·¤Æ¤¤¤Þ¤¹¡£ CREATE TABLE ADDON ( PROGRAM_ID varchar (10) primary key NOT NULL , ADDON_NAME varchar(50) NULL , FILE_NAME varchar (50) NULL ); ¾åµ¤Î3¤Ä¤Î¤¦¤Á¤Î¤É¤ì¤«¤Ë2¥Ð¥¤¥ÈÌܤ¬0x5C¤Î¥Þ¥ë¥Á¥Ð¥¤¥Èʸ»ú¤Ç ½ª¤ï¤ëÃÍ(½¸·×ɽ¤Ê¤É)¤òÆþÎϤ·¤Æ¡¢¹Ô¤ò°ÜÆ°¤¹¤ë¤È ¡ÖODBC--¥ê¥ó¥¯¥Æ¡¼¥Ö¥ë 'addon'¤Ø¤ÎÁÞÆþ¤ß¼ºÇÔ¤·¤Þ¤·¤¿¡£¡× ¤¬È¯À¸¤·¤Þ¤¹¡£ ¤³¤Î¤È¤¤Îʸ»ú¥³¡¼¥É¤Ç¤¹¤¬ Server Client sjis sjis sjis utf8 utf8 sjis utf8 utf8 ¤Ç»î¤·¤¿t¤³¤í¡¢¤³¤Î¸½¾Ý¤¬¤Ç¤ë¤Î¤ÏClient¤¬sjis¤Î¥Ñ¥¿¡¼¥ó¤Ç client¤¬utf8¤Î¥Ñ¥¿¡¼¥ó¤Ç¤Ï¡¢¥Þ¥ë¥Á¥Ð¥¤¥Èʸ»ú¤òÆþÎϤ·¤Æ¤â ¶õʸ»ú¤ÇÅÐÏ¿¤µ¤ì¤Þ¤¹¡£ ¤³¤ì¤Ç¤ªÊ¬¤«¤ê¤Ë¤Ê¤ê¤Þ¤¹¤Ç¤·¤ç¤¦¤«¡© P.S. mysql¥³¥Þ¥ó¥É´Ä¶¤«¤é¤Ï client¤òsjis¤Ë¤·¤¿¾ì¹ç¤Ï insert into addon values('aaa','½¸·×ɽ','dddd'); ¤ò¼Â¹Ô¤·¤¿¤È¤³¤í¡¢ÌäÂê¤Ê¤¯ÄɲäǤ¤Þ¤·¤¿¡£ ¤³¤ÎÃͤâAccess2000¤«¤éÀµ¤·¤¯É½¼¨¤Ç¤¤Þ¤¹¡£ ¤¿¤À¤·¡¢Êѹ¹¤¬¤«¤«¤ë¤ÈƱ¤¸¥¨¥é¡¼¤¬¤Ç¤Þ¤¹¡£ client¤ò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]