14 ms·
My preference would be a flag that you can set per connection. NULL = Undefined or No Data. Whereas a blank field can, in and of itself, be data. It may indica
by Tactic 7y ago
My preference would be a flag that you can set per connection.
NULL = Undefined or No Data. Whereas a blank field can, in and of itself, be data. It may indicated something is intentionally left blank.
But for those times where you want to consider them the same, it would be nice to have a setting.
(Note that I admit the possibility that this may exist already, like most my great ideas.)
- SigmundA 7y agoIn MSSQL you have SET ANSI_NULLS OFF to do this.