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.