distal-attribute
distal-attribute
distal-attribute
distal-attribute

default value for mediumtext

Saturday3AM posted 6 years ago in General
Why is it not possible to set a default value for mediumtext? I want it to be an empty string if not set to anything.

I'm using the latest build (2064).
siMKin posted 6 years ago

wrote: BLOB and TEXT columns cannot have DEFAULT values.


http://dev.mysql.com/doc/refman/5.0/en/blob.html

But, you can set it to NOT NULL, which has the desired result

Please login to leave a reply, or register at first.