Conjurer Posted October 20, 2003 Share Posted October 20, 2003 I am going to have a registration form that contains some required fields and some optional fields. When I create the table to hold these values I know the required fields should be set to Not Null. What is the common practice on the optional fields -- do you set them to Null or do you set them to Not Null and put a blank space \' \' in the default value? Thanks for your help. Quote Link to comment Share on other sites More sharing options...
wolf Posted October 22, 2003 Share Posted October 22, 2003 Hi, i\'ll tell you what i\'ve learnt in my University. I try not to use null fields because it could be a problem with some functions and programs. I don\'t know what is the database for but I would work with \'\' or DEFAULTS values. Good luck. Aahh, sorry if my english wasn\'t good enough, i speak spanish and i loose a little practice speaking english. 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.