Support for TEXT data differs between Adaptive Server, SQL Anywhere, and SAP Sybase IQ.
Adaptive Server supports up to 2GB with LONG VARBINARY (LONG BINARY in SQL Anywhere) and TEXT. SQL Anywhere does not support LONG VARBINARY as a column type, but uses LONG BINARY for the same purpose. 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.