SQL Dialects Reference/Data structure definition/Data types/Large object types

From Wikibooks, the open-content textbooks collection

Jump to: navigation, search

[edit] Large object types

Feature DB2 Firebird Ingres MSSQL MySQL Oracle PostgreSQL SQLite Virtuoso Linter
Character LOBs CLOB(n) BLOB SUB_TYPE 1 CLOB,
TEXT,
LONG VARCHAR		 TEXT / NTEXT
VARCHAR(MAX) / NVARCHAR(MAX) [1]		 TEXT CLOB TEXT TEXT LONG VARCHAR BLOB
Binary LOBs BLOB(n) BLOB SUB_TYPE 0 BLOB,
LONG BYTE		 IMAGE
VARBINARY(MAX)		 BLOB(n) BLOB BYTEA, lo BLOB(n) LONG VARBINARY BLOB

Notes:

  1. ↑ The VARCHAR(MAX) / NVARCHAR(MAX) / VARBINARY(MAX) data types are introduced in SQL Server 2005 and allow texts up to 2GB without the programming limitations of the TEXT / NTEXT / IMAGE data types
Retrieved from "http://en.wikibooks.org/wiki/SQL_Dialects_Reference/Data_structure_definition/Data_types/Large_object_types"