HP Neoview Data Types - VARCHAR

Versions: HP Neoview 2.4, 2.3 and 2.2

HP Neoview - VARCHAR
Syntax	VARCHAR(n) [CHARACTERS]
Data	Variable-length character data, single-byte and multibyte character sets
Parameters	n is the maximum number of characters, mandatory
Range	1 ⇐ n ⇐ (32708 - size of other columns)
Padding	Not padded with spaces to n
Character Set	Database default, unless it is specified using the CHARACTER SET clause
Storage Size	n*charsize
Synonyms	CHARACTER VARYING, CHAR VARYING
Standards	ANSI SQL

HP Neoview VARCHAR - Equivalents in Other Databases

Database	Data Type and Conversion
Oracle	VARCHAR2(n), 1 ⇐ n ⇐ 4000/charsize
SQL Server	VARCHAR(n), 1 ⇐ n ⇐ 8000
IBM DB2	VARCHAR(n), 1 ⇐ n ⇐ 32672
MySQL	VARCHAR(n), 1 ⇐ n ⇐ 65535
PostgreSQL	VARCHAR(n), 1 ⇐ n ⇐ 1G
Sybase ASE	VARCHAR(n), 1 ⇐ n ⇐ pagesize (2K, 4K, 8K or 16K)
Sybase ASA	VARCHAR(n), 1 ⇐ n ⇐ 32767/charsize
Informix	VARCHAR(n, r), 1 ⇐ n ⇐ 255, LVARCHAR(n), 1 ⇐ n ⇐ 32739
Teradata	VARCHAR(n), 1 ⇐ n ⇐ 64000/charsize
Interbase/Firebird	VARCHAR(n), 1 ⇐ n ⇐ 32765/charsize
Ingres	VARCHAR(n), 1 ⇐ n ⇐ 32000; TEXT(n), 1 ⇐ n ⇐ 32000; LONG VARCHAR, 2G; LONG NVARCHAR, 2G, Unicode - UTF-8

Data Types
Fixed-length Character Data	CHAR(n)	NCHAR(n)
Variable-length Character Data	NVARCHAR(n)

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird

Ingres