Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Database Migration Request SQLWays

Ingres Data Types - LONG NVARCHAR

Versions: Ingres 9.x and 10.0

Ingres - LONG NVARCHAR
Syntax LONG NVARCHAR
Data Variable-length character data in the predefined character set - UTF8
Range 2G
Notes These columns cannot be directly compared to other string data types.
To compare a long nvarchar column to another string data type, apply a coercion function.
A string literal of more than 1000 characters cannot be assigned to a long nvarchar column.
Standards ANSI SQL

Ingres LONG NVARCHAR - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NVARCHAR2(n), 1 ⇐ n ⇐ 4000/charsize, Unicode - UTF-8 or UTF-16; NCLOB, 4G, Unicode - UTF-8 or UTF-16
SQL Server NVARCHAR(n | max), 1 ⇐ n ⇐ 4000, 2G if max is specified
MySQL LONGTEXT, 4G
PostgreSQL TEXT, 1G
Sybase ASE UNITEXT, 2G, Unicode
Informix TEXT, 2G, CLOB, 4T
HP Neoview VARCHAR(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) NVARCHAR(n)
Character Large Objects TEXT(n) LONG VARCHAR

All Data Types


Ispirer Home Page Ispirer SQLWays Product Page - Database Migration Request SQLWays

sqlways/ingres/data-types/long_nvarchar.txt · Last modified: May 07, 2018, 03:15:28 PM (external edit)
 
© 1999-2022, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement