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

mysql:15392

From: ¤é¤Ã¤Á¤ç ¤é¤Ã¤Á¤ç <¤é¤Ã¤Á¤ç ¤é¤Ã¤Á¤ç <zon1966@xxxxxxxxxx>>
Date: Fri, 10 Sep 2010 02:04:29 +0000
Subject: [mysql 15392] Re: ÆÃÄêʸ»úÎó insert »þ¤Ëʸ»ú²½¤±¤¹¤ë


¤¿¤Á¤«¤ï¤µ¤ó¡¢¤³¤ó¤Ë¤Á¤Ï¡£

¤é¤Ã¤Á¤ç¡¢¤È¿½¤·¤Þ¤¹¡£

»ä¤Î´Ä¶­¤Ï¤Á¤ç¤Ã¤È°ã¤¦¤Î¤Ç¤¹¤¬¡¢¤´»²¹Í¤Ë¤Ê¤ì¤Ð¤È¡£

 

ODBC¤Ï5.1.7¤¬½Ð¤Æ¤¤¤Þ¤¹¡£

ÀßÄê¤Î¡ÖDetails¡×¤Î¡Ö£Í£é£ó£ã Options¡×¥¿¥Ö¤Î¡ÖCharacter Set¡×¤Ç

"utf8"¤òÁªÂò¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£

¤³¤ì¤Ç²þÁ±¤·¤Ê¤«¤Ã¤¿¤é¡£¡£¡£¡¡¥¹¥ß¥Þ¥»¥ó

 

#¥ê¥ó¥¯¥Æ¡¼¥Ö¥ëľÁàºî¤ÈSQL¤Ç¾É¾õ¤¬°ã¤¦¤Î¤Ïʬ¤«¤ê¤Þ¤»¤ó^^;

 

¤Ç¤Ï¡Á


 
> Date: Wed, 8 Sep 2010 18:49:40 +0900
> From: mailing@xxxxxxxxxx
> Subject: [mysql 15388] ÆÃÄêʸ»úÎó insert »þ¤Ëʸ»ú²½¤±¤¹¤ë
> To: ml@xxxxxxxxxx
> 
> ½é¤á¤ÆÅê¹Æ¤·¤Þ¤¹¡£
> 
> ´Ä¶­
> 
> ¡ü¥µ¡¼¥Ð¦
> 
> OS : Windows Server 2003
> DB : Mysql 5.0.86-community-nt
> DBʸ»ú¥³¡¼¥É : utf8
> 
> 
> ¡ü¥¯¥é¥¤¥¢¥ó¥È
> 
> OS : Windows XP Professional
> ACCESS 2007
> ODBC : 3.51.27
> 
> 
> ¡ü¸½¾Ý
> 
> ¡Ê£±¡ËDB¥ª¥Ö¥¸¥§¥¯¥È¤ò»È¤Ã¤ÆODBC·Ðͳ¤ÇľÀÜÀܳ¤·¤Æ
> ¡¡¡¡¡¡varchar ¹àÌܤËINSERTʸ¤ÇÄɲäò¹Ô¤¦¤È¡¢ÆÃÄêʸ»úÎó¤Çʸ»ú²½¤±¤¬
> ¡¡¡¡¡¡µ¯¤­¤¿¤ê¡¢SELECTʸ¤Çvarchar¹àÌܤËÂФ¹¤ë¾ò·ïʸ»úÎó¤¬
> ¡¡¡¡¡¡ÆÃÄêʸ»úÎó¤Î¤È¤­¤Ë¥¨¥é¡¼¤È¤Ê¤êSQLʸ¤¬¼Â¹Ô¤Ç¤­¤Ê¤¤
> 
> 
> ¡¡¡¡ex '¸Þ½½Íò'¤ò´Þ¤àʸ»úÎó¤òINSERT¤¹¤ëSQL¤ò¼Â¹Ô¤¹¤ë¤È
> ¡¡ ¡¡¡¡ ʸ»ú²½¤±¤·¤ÆÅÐÏ¿¤µ¤ì¤ë¡£
> 
> 
> ¡Ê£²¡Ë¤¹¤Ù¤Æ¤Îʸ»ú¤Çʸ»ú²½¤±¤¹¤ë¤ï¤±¤Ç¤Ï¤Ê¤¯¡¢ÆÃÄêʸ»úÎó¤Çµ¯¤­¤ë
> 
> ¡Ê£³¡Ë¥ê¥ó¥¯¥Æ¡¼¥Ö¥ë¤òľÀÜÁàºî¤¹¤ë¾ì¹ç¤Ë¤Ï¡¢Ê¸»ú²½¤±¤Ïµ¯¤­¤Ê¤¤
> 
> ¡¡¡¡¡¡ex ¥ê¥ó¥¯¥Æ¡¼¥Ö¥ë¤ò´ð¤Ë¥Õ¥©¡¼¥à¤òºî¤ê¡¢¥Æ¥­¥¹¥È¥Ü¥Ã¥¯¥¹¤Î
> ¡¡¡¡¡¡¡¡ ¥Ç¡¼¥¿¥½¡¼¥¹¤ËÌäÂê¤Îµ¯¤­¤Æ¤¤¤ë¹àÌܤò³ä¤êÅö¤Æ¤Æ
> ¡¡¡¡¡¡¡¡ ²èÌ̤«¤é¡Ö¸Þ½½Íò¡×¤òÆþ¤ì¤ë¤Èʸ»ú²½¤±¤»¤º¤ËÅÐÏ¿¤Ç¤­¤ë
> 
> 
> ¥Æ¡¼¥Ö¥ë¥ê¥ó¥¯¤·¤¿¾ì¹ç¤È¡¢Ä¾ÀܤĤʤ¤¤À¾ì¹ç¤Ç¡¢ACCESSÆâ¤Ç
> ¤Ê¤Ë¤«¤·¤«¤Î½èÍý¤Î°ã¤¤¤¬¤¢¤ë¤Î¤Ç¤·¤ç¤¦¤«¡©
> 
> ¡¦Á´¤Æʸ»ú²½¤±¤·¤Æ¤¤¤ë¤Ê¤éʸ»ú¥³¡¼¥É¤ÎÌäÂê¤ÈȽÃǤǤ­¤ë¤Î¤Ç¤¹¤¬
> ¡¡ÆÃÄêʸ»úÎó¤Ç¤ª¤­¤Æ¤¤¤ë¤³¤È
> 
> ¡¦SELECTʸ¤Î¾ò·ï¤Ç¤â¡¢ÌäÂ꤬µ¯¤­¤ë¤³¤È¤«¤éSQLʸ¤ËÆÃÄêʸ»úÎó¤¬
> ¡¡Æþ¤Ã¤¿¤È¤­¤Ë¡¢SQL¤Î²òÀϤ˼ºÇÔ¤·¤Æ¤¤¤ë¡©
> 
> ¡¦Àܳ»þ¤Î¥Ñ¥é¥á¡¼¥¿¤¬Â­¤ê¤º¤Ë¤ª¤Á¤Æ¤¤¤ë¤Î¤«¤Ê¤È¤ª¤â¤¦¤¬¡¢
> ¡¡ÆÃÄêʸ»úÎó¤Î¾ì¹ç¤ËȯÀ¸¤·¤Æ¤¤¤ë¡£
> 
> 
> ¤Ê¤É¤Ê¤É¡¢¤Ê¤¾¤À¤é¤±¤Ç¤¹¡£
> 
> ƱÍͤθ½¾Ý¤ò²óÈò¤µ¤ì¤¿·Ð¸³¤Î¤¢¤ëÊý¤¬¤ª¤é¤ì¤Þ¤·¤¿¤é
> À§Èó¡¢ÃηäòÂߤ·¤Æ¤¯¤À¤µ¤¤¡£
> 
> ¤è¤í¤·¤¯¤ª¤Í¤¬¤¤¤·¤Þ¤¹¡£
> 
> 
> 
> 
> 2010.9.8¡¡¤¿¤Á¤«¤ï¤Ò¤í¤È¤·
> 
 		 	   		  

źÉÕ¥Õ¥¡¥¤¥ë

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

     15388 2010-09-08 18:49 [ΩÀîÇîÉÒ¡Êmailing¼õ¿] ÆÃÄêʸ»úÎó insert  »þ¤Ëʸ»ú²½¤±¤¹¤ë     
   @ 15389 2010-09-08 22:53 ¨²[lime lime <limetibi@]                                       
     15390 2010-09-08 23:02 ¨²[Masaaki Matsuyama <m]                                       
     15391 2010-09-09 00:24 ¨­¨±[ΩÀîÇîÉÒ¡Êmailing¼õ¿]                                     
-> @ 15392 2010-09-10 11:04 ¨±[¤é¤Ã¤Á¤ç ¤é¤Ã¤Á¤ç <z]