MySql Query Error

[-CrAzY-]

I Want To Have It So When You Sign Up Your Profile Sig Is Firstly: No Information On File

This What Happens When I Try:

Error

SQL query:

ALTER TABLE `users` CHANGE `signature` `signature` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'No Information On File'

MySQL said:

#1101 - BLOB/TEXT column 'signature' can't have a default value

Can Someone Help

[hamster01]

Re: MySql Query Error

Text can't have a default value, it is not like int or varchar.

Try altering the mysql query that inserts the user upon registration.

, 'No Information On File', 

 

That should work because you are inserting data with the other info.