mySQL and defaults

[Bob Sneidar]

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