mySQL and defaults

Bob Sneidar bobs at twft.com
Thu Mar 17 13:18:19 EDT 2011


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:

	<snip>

	•  BLOB and TEXT columns cannot have DEFAULT values.


The last line would lead you to believe that CHAR and VARCHAR types CAN have default values, but nay. This produces a syntax error. Any way around this?

Bob



More information about the use-livecode mailing list