Though really, this shouldn't be done in this way at all (i.e. having to rebuild mysql with some flag that has unknown potential other effects..) It's OK to implement it in such a way that columns with not-NULL constraints automatically get some default. What's wrong is in hard-coding an error if you *do* specify a NULL default, unless you build with some odd flag. I.e. this behavior should be dynamic, not static. This is a needless compile-time flag. -----Original Message----- From: stefan mojschewitsch [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 06, 2001 7:23 PM To: mysqllist Subject: Re: NULL value in VARCHAR fields SOLVED hi list, thanx for answering my question. i recompiled mysql with CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS and now it works for me. special thx to Shankar, who declared my problem in better words than mine and to Paul for knowing all from mysqlDocu. ttfn stefan -- st3V13h nach diktat verreist
