Comment by SigmundA

Interesting I have definitely used the distinction between null and empty string quite a bit in MSSQL and matches most programming languages.

Another issue that used to exist was Oracle table name were limited to like 12 characters or something so I have seen horrible abbreviated table names to fit in the Oracle limitation even in other DB's due to some systems being able to run on both MSSQL and Oracle even though SQL Server has a 255 char limit for table names.