Hacker News new | ask | show | jobs
by Tactic 2330 days 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.)

1 comments

In MSSQL you have SET ANSI_NULLS OFF to do this.