XNLVarChar

Specifies the maximum size of both varchar and varbinary results. If the maximum size is exceeded, the datatype is promoted to text and image, respectively.

Syntax

XNLVarChar=integer

Default

256

Values

integer is a valid number between 256 and 2147483647.

Comments

Sybase recommends that the value match the maximum size of the varchar and varbinary datatypes of the back-end database. It is common for this limit to be the same for the varchar and varbinary datatypes.