[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

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]