Previous Topic

Next Topic

Inhoudsopgave

Book Index

(Var)Char( 16384 ), NChar( 16384 ) and NVarChar( 16384 )

In ASE, you can create char and varchar 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)char(max). Variables and columns of the type (var)char(max) can contain up to 4 GB of information.

In ASE, nchar and nvarchar values also can be declared up to a maximum of 16,384 positions. You have to bear in mind that in ASE, nchar and nvarchar are UTF-8 encoded. In MS SQL Server nchar and nvarchar are UTF-16 encoded. The MS SQL Server data types nchar and nvarchar correspond to the ASE data types unichar and univarchar.