Developing Portable Applications > Developing Portable Applications > Application Considerations > Data Type Limits > Nchar(n) Data Type
Was this helpful?
Nchar(n) Data Type
Limits for the nchar(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. For detailed information about individual gateways, see the sections that follow.
DBMS
Nchar(n) Data Type Limits
Microsoft SQL Server
1–4000
Oracle
1–1000
ODBC
Host-specific; refer to SQLGetTypeInfo()
Oracle
Nchar(n) returned from row returning/producing procedures/functions in Oracle are blank padded. With Ingres, they are not blank padded.
Last modified date: 08/22/2022