´Ä¶­¡§
­¡¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¡¡¡¡¡§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/