Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle Data Types - LONG

Versions: Oracle 11g, 10g, 9i, 8i and 7.3

Oracle - LONG
Syntax LONG
Data Variable-length character data
Range 2G
Notes LONG columns are supported only for backward compatibility, they are not recommended for use. A table can contain only one LONG column
Standards Oracle Extension

Oracle LONG - Equivalents in Other Databases

Database Data Type and Conversion
SQL Server VARCHAR(max) or TEXT, 2G
PostgreSQL TEXT, 1G
Sybase ASE TEXT, 2G
Informix TEXT, 2G, CLOB, 4T
HP Neoview VARCHAR(n), 1 ⇐ n ⇐ (32708 - size of other columns)

Related Data Types in Oracle

Data Types
Fixed-length Character Data CHAR(n) NCHAR(n)
Variable-length Character Data VARCHAR2(n) NVARCHAR2(n)
Character Large Objects CLOB NCLOB

All Data Types

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