Developing Portable Applications : 3. Application Considerations : Data Type Limits : Nvarchar(n) Data Type
 
Share this page                  
Nvarchar(n) Data Type
Limits for the nvarchar(n) data type, where (n) is the numeric character length, are summarized in the following table. The gateway requires the length to be explicitly specified. If length is not specified, it will trigger a gateway syntax error. This differs from the Ingres DBMS, which defaults the length to 1 if it is not specified.
DBMS
Nvarchar(n) Data Type Limits
Microsoft SQL Server
1—4000
Oracle
1—2000
DB2 UDB
Not supported