We’re rewarding the question askers & reputations are being recalculated! Read more.
2 added 82 characters in body
source | link

I don't think it matters much, but I like it better when the NULL is there.

When I view the data displayed in a table (like in SQL Server Management Studio), I can better distinguish a missing value if it says NULL and the background is of different colour.

If I see a blank space, I am always wondering if it's really empty or there's some whitespace or some invisible characters. With NULL it's guaranteed empty on the first sight.

enter image description here

I usually don't distinguish the values in the application, because it's unexpected and weird that NULL and empty string would mean something different. And most of the time, I take a defensive approach and just deal with both states. But for me as a human, NULL is easier to process when looking at the data.

I don't think it matters much, but I like it better when the NULL is there.

When I view the data displayed in a table (like in SQL Server Management Studio), I can better distinguish a missing value if it says NULL and the background is of different colour.

If I see a blank space, I am always wondering if it's really empty or there's some whitespace or some invisible characters. With NULL it's guaranteed empty on the first sight.

enter image description here

I usually don't distinguish the values in the application, because it's unexpected and weird that NULL and empty string would mean something different. But for me as a human, NULL is easier to process when looking at the data.

I don't think it matters much, but I like it better when the NULL is there.

When I view the data displayed in a table (like in SQL Server Management Studio), I can better distinguish a missing value if it says NULL and the background is of different colour.

If I see a blank space, I am always wondering if it's really empty or there's some whitespace or some invisible characters. With NULL it's guaranteed empty on the first sight.

enter image description here

I usually don't distinguish the values in the application, because it's unexpected and weird that NULL and empty string would mean something different. And most of the time, I take a defensive approach and just deal with both states. But for me as a human, NULL is easier to process when looking at the data.

1
source | link

I don't think it matters much, but I like it better when the NULL is there.

When I view the data displayed in a table (like in SQL Server Management Studio), I can better distinguish a missing value if it says NULL and the background is of different colour.

If I see a blank space, I am always wondering if it's really empty or there's some whitespace or some invisible characters. With NULL it's guaranteed empty on the first sight.

enter image description here

I usually don't distinguish the values in the application, because it's unexpected and weird that NULL and empty string would mean something different. But for me as a human, NULL is easier to process when looking at the data.