OS: win XP mysql : 3.23.54-max can someone help me with this unexplainable question.
i create this in the mysql database, CREATE TABLE `foo` ( `num` int(4) unsigned zerofill NOT NULL default '0000' ) TYPE=MyISAM; after that, i tried to insert a blank data into it, INSERT INTO foo set num=''; *(there's nothing between the quotes) In the database it display 4 zeros which is 0000, but when i perform a search of an empty string like this, SELECT * FROM foo WHERE num=''; The result was 0000, by right it will hav an empty set. How could this happen? Please help __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php