Martin Engelschalk wrote:
The problem seems to be that sqlite makes a difference between an empty string and a null value.
s/sqlite/SQL/The SQL standards all say that nulls never compare equal to anything, not even other nulls. SQLite's behavior here is the correct one.