The specially licensed Large Objects Management option has been enhanced to include implicit conversion between the LONG VARCHAR data type and CHAR and VARCHAR data types and between the LONG BINARY data type and BINARY and VARBINARY data types for INSERT and UPDATE.
Support has also been added for explicit conversion from the LONG VARCHAR data type to CHAR and VARCHAR data types and from the LONG BINARY data type to BINARY and VARBINARY data types using the CAST and CONVERT functions.
Use of the STRING_RTRUNCATION database option is also supported for LONG BINARY and LONG VARCHAR data type conversion.
For more details on these enhancements, see Chapter 2, “Binary Large Object (BLOB) data,” and Chapter 3, “Character Large Object (CLOB) data,” in Large Objects Management in Sybase IQ, which is included in the Sybase IQ documentation set.
To install this feature, you must enter a license key provided in Sybase IQ Large Objects Management Option Installation Key, a paper document you receive when you purchase the Large Objects Management option.
