Save empty string fields as NULL
Some databases allow saving an empty string optionally as NULL or as empty string. Query result can differ depending on how the string was saved.
select *
from test_table
where str is null
will return strings that were saved as NULL values
select *
from test_table
where str = ''
will return strings that were saved as empty strings
We can add an EmptyStringAsNull option, which will force saving empty strings as NULL values.
24
votes
AdminDevart
(_, Devart)
shared this idea