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]