Page History

How does Empire-DB handle '' (empty string)

Empire-DB internally treats all empty strings as null and this behavior is by design.
Some databases accept empty strings as a valid value for a text column, others don’t.
However allowing empty strings is a major reason for many database problems and changing the empire-db code here would have a major impact on existing projects.
We have thought about this a long time ago and we came to the conclusion that empty strings are evil and should be avoided completely.
In fact NULL has a logical meaning of a value not being supplied for a field but what different logical meaning would an empty string have instead?

...