Ispirer Website Ispirer Capabilities - Ingress Migration Free Trial

Ingres Data Types - NVARCHAR

Versions: Ingres 9.x and 10.0

Ingres - NVARCHAR
Syntax NVARCHAR(n)
Data Variable-length character data in the predefined character set - UTF8
Parameters n is the maximum number of characters, optional
Range 1 ⇐ n ⇐ 16000 (32000 bytes is the maximum row size shared among all columns)
Default n is mandatory
Trailing Spaces Not removed when the value is stored and retrieved.
But trailing spaces are insignificant in comparisons, primary and unique keys
Storage Size Actual entry length
Standards ANSI SQL

Ingres NVARCHAR - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NVARCHAR2(n), 1 ⇐ n ⇐ 4000/charsize, Unicode - UTF-8 or UTF-16
SQL Server NVARCHAR(n | max), 1 ⇐ n ⇐ 8000, 2G if max is specified, Unicode - UCS-2
MySQL NVARCHAR(n), 1 ⇐ n ⇐ 21845, Unicode - UTF-8
PostgreSQL VARCHAR(n), 1 ⇐ n ⇐ 1G
Sybase ASE NVARCHAR(n), 1 ⇐ n ⇐ pagesize/@@ncharsize (page size is 2K, 4K, 8K or 16K);
UNIVARCHAR(n), 1 ⇐ n ⇐ pagesize/@@unicharsize, Unicode
Informix NVARCHAR(n,r), 1 ⇐ n ⇐ 255, LVARCHAR(n), 1 ⇐ n ⇐ 32739
HP Neoview NVARCHAR(n), 1 ⇐ n ⇐ (32708 - size of other columns)

Related Data Types in Ingres

Data Types
Fixed-length Character Data CHAR(n) NCHAR(n)
Variable-length Character Data VARCHAR(n)
Character Large Objects TEXT(n) LONG VARCHAR LONG NVARCHAR

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.