Is it better to use the NULL keyword in a char field of a database or an empty string ("").
Which is faster and more robust?
In general
NOT NULL fields and empty strings (or zeros) are considered best in database design. Makes for faster searches, particularly if searching on the field in question.
Conclusion: it's better to use an empty string or an integer (0) as a value for an empty field.
