SQL Anywhere (SA) can store large objects (up to a 2GB maximum length) in columns of data type LONG VARCHAR or LONG BINARY. The support of these data types by SQL Anywhere is SQL/2003 compliant. SQL Anywhere does not support the BYTE_LENGTH64, BYTE_SUBSTR64, BFILE, BIT_LENGTH, OCTET_LENGTH, CHAR_LENGTH64, and SUBSTRING64 functions.
Adaptive Server® Enterprise (ASE) can store large text objects (up to a 2GB maximum length) and large binary objects (up to a 2GB maximum length) in columns of data type TEXT or IMAGE, respectively. The support of these data types by Adaptive Server Enterprise is an ANSI SQL Transact-SQL® extension.
