Hi folks,
I have discovered that on MySQL, when I set sql_mode='strict_all_tables', it throws an error wherever you try and make a text column with a default.
The documentation confirms it's how MySQL is designed to behave, without giving any reason why: http://dev.mysql.com/doc/refman/5.0/en/blob.html
Does anyone know why this would be the case, and if there's any nice workaround other than unsetting that sql mode?
Databases: MySQL: BLOB/TEXT column 'authorname' can't have a default value
by Nigel McNie -
Number of replies: 0