Geeks With Blogs

News Ashraful Alam Joy

Create Your Badge

Ashraful Alam is a Software Architect, who has 8 years of professional experience in Software Development industry. This Bangladeshi national is involved with project management and development of several US based software projects from his country. Already he has managed and developed several software projects, which are being used by several users of different countries, such as USA, Canada, Australia, and Bangladesh. While developing and managing a team, he contains and maintains a set of well defined engineering practices developed by him and other online developer communities.

Due to his willingness to give effort to improve and share better software development practices, Ashraf has been awarded as “Most Valuable Professional” (MVP) in ASP.NET category by Microsoft since year 2007 multiple times, which is a rare honor and prestigious reorganization among the developers around the world.

Check his portfolio to know more about him and his works.

.NETTER Characters... Every part of your life is best, if you can know yourself and thus create your life like an artist!


Null values are one of the basic considerations, without taking care of which may raise lots of confusions and errors while the application is running in the live. Some application architecture supports a model which puts null values to the database while the user is providing empty data from the user interface end. For string/text type data some times are saved as empty string (i.e. string.empty). But it creates confusion where empty string itself considered as a value. Also, besides string/text type data, special care are required for other type of data (number, fraction, date time etc) with respect to null values to be saved and retrieved to and from the physical database tables. These considerations are required to be addressed in this point.

Technorati Tags: ,
Posted on Monday, April 21, 2008 12:12 PM | Back to top

Comments on this post: Design Factors 16: How the null values are handled?

# re: Design Factors 16: How the null values are handled?
Requesting Gravatar...
I think we should always make a field Nullable in the database if its optional. In my view, using string length function to check the existance of data in a field is not a best approach.
Left by Jawwad Alam on Jan 06, 2009 3:08 AM

Your comment:
 (will show your gravatar)

Copyright © Ashraf Alam | Powered by: