Support for TEXT data is currently implemented as follows:
Adaptive Server Enterprise and Adaptive Server Anywhere support up to 2 GB with LONG VARBINARY 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 Large Objects Management in Sybase IQ.