MySQL Bugs: #51259: BLOB and TEXT columns cannot have DEFAULT values.

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:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

This is a duplicate of bug #21532.