Support for TEXT data differs between Adaptive Server Enterprise, SAP SQL Anywhere, and SAP Sybase IQ.
Adaptive Server Enterprise supports up to 2GB with LONG VARBINARY (LONG BINARY in SAP SQL Anywhere) and TEXT. SAP SQL Anywhere does not support LONG VARBINARY as a column type, but uses LONG BINARY for the same purpose. SAP SQL Anywhere supports up to 2GB with LONG BINARY and TEXT.
SAP Sybase IQ supports up to 32KB - 1 with VARCHAR. SAP Sybase IQ also supports up to 512TB (with an IQ page size of 128KB) and 2PB (with an IQ page size of 512KB) with LONG VARCHAR. For information on the LONG VARCHAR data type in SAP Sybase IQ, see Unstructured Data Analytics.