Previous Topic

Next Topic

Inhoudsopgave

Book Index

UniChar( 8192 ) and UniVarChar( 8192 )

In ASE, you can create unichar and univarchar variables up to a length of 8192 bytes. In MS SQL Server, for nchar and nvarchar, 4,000 characters (= 8,000 bytes) is the maximum. If you need anything larger than that, you have to use nchar(max) or nvarchar(max). Variables and columns of the type nchar(max) or nvarchar(max) can contain up to 4 GB of information, which equals 2,147,483,648 characters of 2 bytes length.