default value for mediumtext

6 posts
[expired user #2117]'s profile image [expired user #2117] posted 15 years ago in General Permalink
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).
106 posts
[expired user #1821]'s profile image [expired user #1821] posted 15 years ago Permalink

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.