default value for mediumtext

Saturday3AM posted 10 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 10 years ago

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.