siliconpi
Reputation: 8297
Storing empty strings vs NULLs in MySQL database?
I have a PHP/MySQL application that stores "blank" values in some cases as '' (empty strings) and in other cases as NULLs.
Having this mixed format certainly causes a problem when comparing, so I’m wondering which one is the better storage mechanism? '' or NULL?
Upvotes: 5
Views: 2848
Answers (1)
Simone Gianni
Reputation: 11672
While this is confusing, actually you should store null for a number of reasons :
- Checking against null is usually faster than checking an empty string in most databases
- Null commonly means "i don't know", empty string means "I know : it's empty". It gives you better semantics.
Upvotes: 8
Related Questions
- MySQL, better to insert NULL or empty string?
- When to use NULL in MySQL tables
- Do we use NULL or 0 for database?
- Use of empty strings instead of null - a good practice?
- Should I use NULL or an empty string to represent no data in table column?
- SQL/MySQL NOT NULL vs NOT EMPTY
- MySql Database Design- most efficient for columns that might be null?
- Dealing with null values versus empty strings in a database when only empty strings are coming from the client via HTTP POST
- NULL in table fields better than empty fields?
- Column Nullability/Optionality: NULL vs NOT NULL