Jump to content


This topic is now archived and is closed to further replies.


One more ? - Optionally blank fields?

Recommended Posts

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.

Share this post

Link to post
Share on other sites

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.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.