Back

Editing, Updating and Creating Records
emptyCharIsNull
If true, then zero length strings are stored as nulls Default: `false` This applies when the metatype is 'C' or 'X' (char and varchar) and strlen($data) == 0. Note that we do not trim the data first, so if you want to also strip off white-space, you will have to do it manually using spEdit or spNew properties. Syntax `# the following fields will store null when the string is empty. $lens->emptyCharIsNull = 'field1;field2';` Basic:No Advanced/Enterprise:Yes DynamicEdit:No [Version 2.7.2]