0

There is a topic here in which is discussed the impacts of inserting a NULL value or an empty value. However, the answers involved both programming and query impacts, and the storage system was not mentioned.

Do the DBMSs (more specifically MySQL and PostgreSQL) make some assumptions whether a value is null or is empty? What is the impact on storage and efficiency?

Community
  • 1
  • 1
Aleksandrus
  • 1,589
  • 2
  • 19
  • 31
  • 1
    possible duplicate of [MySQL: NULL vs ""](http://stackoverflow.com/questions/1106258/mysql-null-vs) – Eric Petroelje Nov 06 '14 at 15:12
  • Unless you can measure it, forget about it. Seriously, we have *terabyte* sized hard drives today. The primary reason for `NULL` is to separate between "empty" and "undefined", nothing more. – tadman Nov 06 '14 at 15:27
  • True, Eric, [THIS](http://stackoverflow.com/a/12706491/3381662) is the answer I was looking for. – Aleksandrus Nov 06 '14 at 15:41

0 Answers0