Re: wrong result when perform search of empty string

2003-01-16 Thread Roger Baklund
* Kwok Siang > 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 > '' > ) TYPE=MyISAM; > > after that, i tried to insert a blank data in

re: wrong result when perform search of empty string

2003-01-16 Thread Victoria Reznichenko
On Thursday 16 January 2003 11:00, Kwok Siang wrote: > 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 > '' > ) TYPE=MyISAM; > > afte