The new CONVERSION_MODE database option lets you restrict implicit conversion from binary data types to any other nonbinary data type on INSERT, UPDATE, and in queries. The restrict binary conversion mode also applies to LOAD TABLE default values and CHECK constraints. Using this option prevents implicit data type conversions of binary information such as encrypted data that would result in semantically meaningless operations.
For more information on the CONVERSION_MODE option and its usage, see “CONVERSION_MODE option” in Chapter 2, “Database Options” in the Sybase IQ Reference Manual.
For more information on column encryption in Sybase IQ, see “Sybase IQ Encrypted Column Option”.
