In Sybase IQ 12.6, if TEMP_EXTRACT_NULL_AS_ZERO is set to ON, the number of characters that an ASCII extract writes to a file for a CHAR or VARCHAR column equals the number of characters in the column. In version 12.5, this situation returned at least four characters. For more information, see “TEMP_EXTRACT_NULL_AS_ZERO option” in Chapter 2, “Database Options” of the Sybase IQ Reference Manual.
