Community Member Profile

Recent Blog Comments By Colin Styles

• Why NULL Values Should Not Be Used in a Database Unless Required

  Posted on Jul 6, 2012 at 8:02 PM

  @David, I agree 99%. I do sometimes use default value spaces, and integer zeroes when I know the values have a specific code equivalent ... like Enumerations and flags. Sometimes necessary in a properly de-normalised database. Database first design has always worked for me too and nul... read more »

• Why NULL Values Should Not Be Used in a Database Unless Required

  Posted on Jun 7, 2012 at 6:11 AM

  Man, this thread is the energizer bunny of threads, it just goes on and on.... read more »

• Why NULL Values Should Not Be Used in a Database Unless Required

  Posted on Apr 22, 2012 at 4:49 AM

  @Mathew, I think the consensus of this post has been that nulls are fine if they serve a purpose. In your case they do serve a valid purpose,that a value has not been entered. Nulls can clutter your code and make it less readable. Nulls can also refine your code and make it more r... read more »

• Why NULL Values Should Not Be Used in a Database Unless Required

  Posted on Jul 15, 2011 at 6:43 PM

  I always check values coming into my code for rational values, whether from a database or user input. Nulls are just a part of that. A good function library can save a lot of pain.... read more »

• Why NULL Values Should Not Be Used in a Database Unless Required

  Posted on Dec 17, 2010 at 1:03 AM

  maybe change your conclusion to: DO NOT ALLOW NULL VALUES unless you know what you are doing . You will only be making things harder for yourself.... read more »