Software
Microsoft
Hardware
Network
Policy
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
internet advertising
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.
Popular Tags
Tags:
5
access
change
column
connect
connection
count
create
data
database
date
error
field
file
from
how
import
insert
join
key
multiple
mysql
mysqldump
one
php
phpmyadmin
procedure
query
rows
select
server
sql
stored
sum
table
tables
update
user
value
Browse All Tags