Developing Portable Applications > Developing Portable Applications > Application Considerations > Data Type Limits > Nvarchar(n) Data Type
Was this helpful?
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
ODBC
Host-specific; refer to SQLGetTypeInfo()
Last modified date: 08/22/2022