Substitution of NULL or Blank Characters

SAP Sybase IQ supports zero-length VARCHAR data.

If the length of a VARCHAR cell is zero, and the cell is not NULL, you get a zero-length cell if the option NON_ANSI_NULL_VARCHAR=OFF.

If NON_ANSI_NULL_VARCHAR=ON, a NULL is inserted.

For all other data types, if the length of the cell is zero, a NULL is inserted.