Sybase IQ now implicitly converts any binary value to a bit column on insertion. Non-zero values are converted to 1 and zero values are converted to 0. This behavior matches that of Adaptive Server Enterprise. For more information on INSERT and UPDATE conversions, see “Data conversions in IQ” in Chapter 7, “Moving Data In and Out of Databases” of the Sybase IQ System Administration Guide.
