Software FAQ » Database » MySQL Server » MYSQL : default value in TEXT or BLOB

MYSQL : default value in TEXT or BLOB
I need to set a default value for texts fields  that are longer than 255 chars

I tried BLOB and TEXT and got a message:

"BLOB 'mailContent' cannot have a default value"

How can I achieve this ?
regards

Solution: MYSQL : default value in TEXT or BLOB

In text and in varchar you can not have default value and in varchar you have a 255 chars limit.

So you have to do a trick independed on what you programming.For example to give to a hidden label a default value that you will store to the field if a user does not type anything in the specific field.
Bookmark and Share
How to update LONG column in Oracle 9i   Putting Javascript in a Wordpress file (not a post) in the Body (not the head)  
ETL for HL7 data into Microsoft SQL Server   browser not sending HTTP_REFERER headers to website  
Problem: How can I disable the caching of EJB 3.0 datasources?   PHPmyadmin  
Installation of Logitech WebCam software   Problem: Wildcard for datapump import  
.bat file to copy zip and unzip files   XHTML: there is no attribute "name"  
Crystal Lawson Report Error   Recover deleted vm esx  
Net Stop /Net start command syntax   Using PHP on webserver, to retrieve a file from a remote PC with ftp server installed  
Regarding Popen in python   SBS Shutting itself down! It says I have multiple domain controllers when I don't!  
Sendmail seems to be relaying using localhost 127.0.0.1 to send mail out   Explanation of RSS  
Text-Diff in RUBY   Problem: Mysql ODBC