dansk Posted January 2, 2007 Share Posted January 2, 2007 ALTER TABLE `articles` CHANGE `Image_Link` `Image_Link` TEXT CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT 'I_Logo.gif'MySQL said: Documentation#1101 - BLOB/TEXT column 'Image_Link' can't have a default value how can i make it have a default value? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 3, 2007 Share Posted January 3, 2007 You can't. Quote Link to comment Share on other sites More sharing options...
dansk Posted January 3, 2007 Author Share Posted January 3, 2007 LOL fenway,that was quick. Can I create a field that if no one inserted anything in there, it would assign it to a default value. I am willing to create a new field to do that. Thank you Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted January 3, 2007 Share Posted January 3, 2007 You can use varchar. Varchar can have a default value. However varchar can only store 255 characters maximum. Text can store about 65,000 characters or more. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.