On 8/20/08, Brian Aker <[EMAIL PROTECTED]> wrote: > > Hi! > > There is nothing in the DB that keeps a blob/text from having a default > value except about seven lines of code (I came across this while working on > modes). Today a warning is issued and we just change the default to a "". > Unless someone has a good reason, I am going to all a default to be set. I > can guess about why this limitation existed at one point... but now? Nope, > not a reason.
I may be missing something.....but can't you specify NOT NULL DEFAULT '' ? In fact wouldn't you want to specify that? Why is this data type different from, say, an INT? An INT doesn't have a default value, you have to specify what you want the default to be. (similarly, I think the DATETIME/TIMESTAMP default value of '0000-00-00 00:00:00' should take a long walk off a short pier). So.....what point am I missing here? -Sheeri
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
