Support for TEXT data differs between Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ.
Adaptive Server Enterprise 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.
Sybase IQ supports up to 32KB - 1 with VARCHAR. 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 Sybase IQ, see Unstructured Data Analytics in Sybase IQ.