mysql:14056
From: akio_takahashi <akio_takahashi <aaakiotakahasi@xxxxxxxxxx>>
Date: Sun, 17 Jun 2007 08:33:53 +0900 (JST)
Subject: [mysql 14056] null ¤¬Ê¸»úÎó"(null)"¤Ë¤Ê¤ë·ï
´Ä¶¡§ ¡¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¡¡¡¡¡§MS ACCESS2002 ¢¥Ç¡¼¥¿¥Ù¡¼¥¹ ¡¡ ¡¡¡¡¡§MySql4.025 £¥Ç¡¼¥¿¥Ù¡¼¥¹ODBC¡§Mysql ODBC 3.51 ¤Mysql¤Î¥µ¡¼¥Ð¤Î¥¥ã¥é¥¯¥¿¥»¥Ã¥È¡¡ujis ¤ªÀ¤Ïäˤʤê¤Þ¤¹¡£¸½ºß¡¢MS ¥¢¥¯¥»¥¹¤Ç£Á£Ä£Ï¡¢ ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ï£Í£ù£ó£ñ£ì¤Ç ¥³¡¼¥Ç¥£¥ó¥° ¤ò¹Ô¤Ê¤Ã¤Æ¤ª¤ê¤Þ¤¹¡£ Î㤨¤Ð¡¢ ¥Æ¡¼¥Ö¥ë£Á ¥Õ¥£¥ë¡¼¥ë¥Éa VARCHAR¡¡NULL¤Ï£Ï£Ë¡Ê¾¤Î¥ª¥×¥·¥ç¥ó¤Ï¤Ä¤±¤Æ¤¤¤Þ¤»¤ó¡Ë ¥Õ¥£¡¼¥ë¥Éb¡¡ VARCHAR¡¡NULL¤Ï£Ï£Ë¡Ê¾¤Î¥ª¥×¥·¥ç¥ó¤Ï¤Ä¤±¤Æ¤¤¤Þ¤»¤ó¡Ë ¥Õ¥£¡¼¥ë¥Éc VARCHAR¡¡NULL¤Ï£Ï£Ë¡Ê¾¤Î¥ª¥×¥·¥ç¥ó¤Ï¤Ä¤±¤Æ¤¤¤Þ¤»¤ó¡Ë ¤Î¥Æ¡¼¥Ö¥ë¤Ç ¥ì¥³¡¼¥É¤ò£±·ïÄɲä·¤Þ¤¹¡£ INSET INTO ¥Æ¡¼¥Ö¥ë£Á(¥Õ¥£¥ë¡¼¥ë¥Éa,¥Õ¥£¡¼¥ë¥Éb) VALUES('TEST1','TEST2') ¥Æ¡¼¥Ö¥ë¤ÎÄɲä·¤¿¥Ç¡¼¥¿¤ÎÃæ¿È¤ò³Îǧ¤·¤Þ¤¹¤È¥Ç¡¼¥¿¤òÄɲ䷤Ƥ¤¤Ê¤¤ ¥Õ¥£¡¼¥ë¥Éc¤¬Ê¸»úÎó¤Ç"(null)"¤Èɽ¼¨¤µ¤ì¤Þ¤¹¡£ ¼«Ê¬¤È¤·¤Æ¤Ï¶õ¤Î¾õÂ֤ˤʤäƤۤ·¤¤¤Î¤Ç¤¹¤¬¡¢£Í£ù£ó£ñ£ì¦¤Ç¤â¡¢¥¢¥¯¥»¥¹Â¦ ¤Ç¤âʸ»úÎó¤È¤·¤Æ¥Õ¥£¡¼¥ë¥Éc¤¬Ê¸»úÎó¤Ç"(null)"¤Èɽ¼¨¤µ¤ì¤Þ¤¹¡£ ¤³¤ì¤Ï¥Æ¡¼¥Ö¥ëÄêµÁ¤ä¥¥ã¥é¥¯¥¿¥»¥Ã¥È¤Ç²ò·è¤Ç¤¤ë¤Î¤Ç¤·¤ç¤¦¤«¡£ ¤â¤Á¤í¤ó INSET INTO ¥Æ¡¼¥Ö¥ë£Á(¥Õ¥£¥ë¡¼¥ë¥Éa,¥Õ¥£¡¼¥ë¥Éb,¥Õ¥£¡¼¥ë¥Éc) VALUES('TEST1','TEST2','') ¤È¥³¡¼¥Ç¥£¥ó¥°¤¹¤ì¤Ð¥Õ¥£¡¼¥ë¥Éc¤Ï¶õʸ»ú¤Çɽ¼¨¤µ¤ì¤Þ¤¹¤¬¡¢ ¥Æ¡¼¥Ö¥ë¤Î¥Õ¥£¡¼¥ë¥É¤òÄɲ乤ëÅ٤˥³¡¼¥Ç¥£¥ó¥°¤â¤·¤Ê¤±¤ì¤Ð¤¤¤±¤Ê¤¤¤Î¤Ç Èó¸úΨ¤«¤È»×¤¤¤Þ¤·¤¿¡£ ¤ªË»¤·¤¤¤È¤³¤í¡¢ÂçÊѶ²½Ì¤Ç¤¹¤¬¡¢¤É¤Ê¤¿¤«null¤¬Ê¸»úÎó"(null)"¤Ë¤Ê¤ë¸½¾Ý¤¬¤ª ¤³¤Ã¤Æ ²ò·èÊýË¡¤ò¤É¤¦¤·¤¿¤«ÃΤäƤé¤Ã¤·¤ã¤ëÊý¤¬¤¤¤Þ¤·¤¿¤é¡¢¶µ¤¨¤Æ¤¤¤¿¤À¤±¤Þ¤¹¤Ç ¤·¤ç¤¦¤«¡£ -------------------------------------- Start Yahoo! Auction now! Check out the cool campaign http://pr.mail.yahoo.co.jp/auction/
-> 14056 2007-06-17 08:33 [akio_takahashi <aaak] null ¤¬Ê¸»úÎó"(null)"¤Ë¤Ê¤ë·ï 14057 2007-06-17 08:56 ¨²[IWASAKI Dai <dai@xxx] 14058 2007-06-17 09:13 ¨²[Ã鸤 KEN¸ø <ken_ken_] 14059 2007-06-17 09:45 ¨²[±óÆ£ ½Ó͵ <endo@xxxx] 14060 2007-06-17 15:18 ¨±["Tetsuro IKEDA" <ikd]