41 results found
-
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 valuesselect *
from test_table
where str = ''
will return strings that were saved as empty stringsWe can add an EmptyStringAsNull option, which will force saving empty strings as NULL values.
24 votes
- Don't see your idea?