Error when creating tables with text columns with default values

OpenEMR Development
1

qlcorp wrote on Thursday, November 12, 2015:

I’m getting the following error when creating tables on CentOS Linux release 7.0.1406 and MySQL Server version: 5.6.27:

ERROR 1101 (42000): BLOB/TEXT column 'comments' can't have a default value

The offending lines have “NOT NULL DEFAULT”, for example:

`comments`            text         NOT NULL DEFAULT '' COMMENT 'comments from the lab',
2

yehster wrote on Thursday, November 12, 2015:

Not specific to OpenEMR. TEXT columns cannot have a default value.

https://dev.mysql.com/doc/refman/5.6/en/blob.html

BLOB and TEXT columns cannot have DEFAULT values.

3

fsgl wrote on Friday, November 13, 2015:

Mini-tutorial.