https://bugzilla.balabit.com/show_bug.cgi?id=23 --- Comment #7 from Mark LaCroix <mark@la-croix.net> 2008-09-26 15:35:11 ---
in text-based fields the empty strings should be '' instead of NULL.
Well, yes and no. Empty strings should be '', but MISSING strings should be NULL. Ideally, missing anything should become a NULL value, at least for the purposes of database insertion. Unfortunately it's not that simple. But it illustrates a core problem with the current DB interface. Everything is being treated as a string in the INSERT statement and there is no way to differentiate between an empty string value and a missing data value. I have tested the patch and it didn't work. A missing PID still produces an empty string in the INSERT statement. -- Configure bugmail: https://bugzilla.balabit.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.