Jump to content


One more ? - Optionally blank fields?

  • Please log in to reply
1 reply to this topic

#1 Conjurer

  • Members
  • PipPipPip
  • Advanced Member
  • 107 posts

Posted 20 October 2003 - 07:58 PM

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.

#2 wolf

  • Members
  • Pip
  • Newbie
  • 4 posts

Posted 22 October 2003 - 02:50 PM

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.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users