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

mysql:15389

From: lime lime <lime lime <limetibi@xxxxxxxxxx>>
Date: Wed, 8 Sep 2010 22:53:18 +0900
Subject: [mysql 15389] Re: ÆÃÄêʸ»úÎó insert »þ¤Ëʸ»ú²½¤±¤¹¤ë

¤³¤ó¤Ð¤ó¤Ï¡£MySql¤Ç¤Ï¤Ê¤¯Oracle¤Ç¤¹¤¬¡¢ÆÃÄê¤Î´Á»ú¤òInsert¤·¤è¤¦¤È¤·¤Æ¥¨¥é¡¼¤Ë¤Ê¤Ã¤¿»ö¤¬¤¢¤ê¤Þ¤¹¡£

DB¤È¥µ¡¼¥Ð¤Çʸ»ú¥³¡¼¥É¤¬°Û¤Ê¤Ã¤Æ¤¤¤¿¤¿¤á¡¢
ʸ»ú¥³¡¼¥ÉÊÑ´¹¤ÇÀ©¸æʸ»ú¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¤¡¢¥¨¥é¡¼¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤·¤¿¡£¡ÊEUC¤ÈS-JIS¤À¤Ã¤¿¤È»×¤¤¤Þ¤¹¡Ë

¤½¤Î¤È¤­¤Ï¡¢ÁÛÄê³°¤Î¥Ç¡¼¥¿¤À¤Ã¤¿¤Î¤ÇÅÐÏ¿¤·¤Ê¤¯¤Æ¤â¤è¤¯¡¢
À©¸æʸ»ú¤¬Æþ¤Ã¤Æ¤¤¤¿¤é¤Ï¤¸¤¯¤è¤¦¤Ë¤·¤Þ¤·¤¿¡£
²¿¤«¤Î¤´»²¹Í¤Ë¤Ê¤ì¤Ð¤È»×¤¤¤Þ¤¹¡£


2010ǯ9·î8Æü18:49 ΩÀîÇîÉÒ¡Êmailing¼õ¿®ÍÑ¡Ë <mailing@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]