41 results found

1. 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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  0 comments  ·  Common  ·  Delete…  ·  Admin →