IgnoreZero option
Specifies whether to discard binary value zero in char and varchar fields.
The default is false. If the value is true, the command accepts binary value zeros in input fields and discards them.
This option is not supported for the fixed-length format.