Compatibility

SAP Sybase SQL Anywhere® (SA) and SAP Adaptive Server® Enterprise (ASE) store large text and binary objects.

SQL Anywhere 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 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 is an ANSI SQL Transact-SQL® extension.

A LONG BINARY column of a proxy table maps to a VARBINARY(max) column in a Microsoft SQL Server table.