Ispirer Migration Knowledge Base

User Tools

Site Tools

You are here: Ispirer Migration Knowledge Base » Ispirer Migration Knowledge Base » Oracle Database - Migration Reference » Oracle - Data Types » Oracle Data Types - LONG RAW


User Documentation Ispirer Capabilities - Oracle Migration Pricing

Oracle Data Types - LONG RAW

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

Oracle - LONG RAW
Syntax LONG RAW
Data Variable-length binary data
Range 2G
Notes Oracle strongly recommends to use BLOB data type instead of LONG RAW as it has far fewer restrictions than LONG RAW
Standards Oracle Extension

Oracle LONG RAW - Equivalents in Other Databases

Database Data Type and Conversion
SQL Server VARBINARY(max), 2G, IMAGE, 2G
MySQL LONGBLOB ,4G
PostgreSQL BYTEA ,2G
Sybase ASE IMAGE ,2G
Informix BYTE, 2G, BLOB, 2T

Related Data Types in Oracle

Data Types
Variable-length binary data RAW BLOB

All Data Types

Oracle SQL Server IBM DB2 MySQL PostgreSQL Sybase ASE Sybase ASA Informix DS Teradata HP Neoview Interbase/Firebird
© 1999-2025, Ispirer Systems, LLC. All Rights Reserved.