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

default value for mediumtext

User, date Message
Written by Saturday3AM
6 years ago
Category: General
6 posts since Thu, 26 Apr 07
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).
Written by siMKin
6 years ago
104 posts since Sun, 01 Apr 07

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.