Bug #51259 BLOB and TEXT columns cannot have DEFAULT values.
Submitted: 18 Feb 2010 0:06 Modified: 18 Feb 2010 7:25
Reporter: Larry Hill Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DDL Severity:S4 (Feature request)
Version:5.5+ OS:Any
Assigned to:

[18 Feb 2010 0:06] Larry Hill
Description:
"BLOB and TEXT columns cannot have DEFAULT values."

Any particular reason why not? Even <empty string> would be nice. Ain't fond of NULLs and this clause: WHERE fieldname='' OR ISNULL(fieldname).

How to repeat:
Use MySQL.
[18 Feb 2010 7:25] Valerii Kravchuk
This is a duplicate of bug #21532.