Hello.
On Tue 2003-01-14 at 09:32:02 -0800, [EMAIL PROTECTED] wrote:
> I'm aware that NULL and "" are not the same thing.. I would like to
> prevent the column from accepting values automatically ( with out the
> presence of a DEFAULT).
[...]
The problem is: You have a DEFAULT, you just don't know it. ;-)
Do a SHOW CREATE TABLE stuff, and you'll see what I mean. That is a
known deficiency, as Eric told you:
It's a known behaviour and is described in the MySQL manual:
http://www.mysql.com/doc/en/Bugs.html
You can change it if you compile MySQL server with
-DDONT_USE_DEFAULT_FIELDS option. But in this case you can't use
default values at all.
http://www.mysql.com/doc/en/configure_options.html describes
-DDONT_USE_DEFAULT_FIELDS.
HTH,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
