Re:Problems with Oracle SQL
by MrStonedOne on Friday September 10, 2021 @03:17PM
(#28485888)
Empty string means "we know its blank" null means "we don't know".
When it comes to datatyping, (the whole point of data types in a db), null is its own datatype, so forcing the allowance of nulls to get blank strings is kinda stupid and only causes software/application level bugs.
When it comes to datatyping, (the whole point of data types in a db), null is its own datatype, so forcing the allowance of nulls to get blank strings is kinda stupid and only causes software/application level bugs.