So what is a Null?

Thoughts, comments and discussion from Baycastle staff and partners

Moderators: Tom, ian

So what is a Null?

Postby ian » Wed Apr 23, 2014 1:39 pm

So what is a Null? How does it differ from empty string?

A Null is no data at all and should not be confused with an empty string. Null is a value, used to indicate no data, while an empty string is nothing. As an example a Date field can contain either a valid date or Null. 00/00/0000 is not a valid date and will be rejected while a Null may well be accepted. An Integer field might contain a Null or a Zero as well as a non-zero number. You need to check what is the correct value to import if there is no value. This will depend on the target system, but Null is often a good way to proceed.

Email us and we will do what we can to help.

DataSlave will automatically cast data type if you set the output type to for example DateTime. You can also use cast functions. Be under control of the treatment of data as part of your Data Import plan.

Talk to us and we can help you build your plan for data migration, Data Import or Data Export.
ian
 
Posts: 364
Joined: Sat Dec 18, 2004 8:13 am
Location: UK

Return to Baycastle Blog

Who is online

Users browsing this forum: No registered users and 1 guest

cron