In ASE, you can create binary and varbinary variables up to a length of 16,384 bytes. In MS SQL Server, 8,000 is the maximum. If you need anything larger than that, you have to use (var)binary(max)
. Variables and columns of the type (var)binary(max)
can contain up to 4 GB of information.