Right sorry I discovered this last night too. I think the problem was the
Sequel Quotes. For some reason I was replacing not only double quotes with `
but single ones too. Trouble is, you cannot wrap default values in `. Also, the
reference manual says that text types did not support DEFAULT. I
From the MySQL reference manual on TEXT types:
In most respects, you can regard a BLOB column as a VARBINARY column
that can be as large as you like. Similarly, you can regard a TEXT column as a
VARCHAR column. BLOB and TEXT differ from VARBINARY and VARCHAR in the
following ways:
On Thursday, March 17, 2011 12:18:19 PM Bob Sneidar wrote:
From the MySQL reference manual on TEXT types:
In most respects, you can regard a BLOB column as a VARBINARY
column that can be as large as you like. Similarly, you can regard a TEXT
column as a VARCHAR column. BLOB and
Oh thanks Warren! That will work famously! Unfortunately I just finished the
code that strips all the DEFAULT parameters from all text column definitions
LOL! I guess it's back to work undoing my last undo. Still, nice to know it can
be done.
Bob
On Mar 17, 2011, at 10:51 AM, Warren Samples