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

Large object types datatype3.html Character LOBs CLOB(n) CLOB(n) BLOB SUB_TYPE TEXT CLOB,TEXT,LONG VARCHAR 176089 varchar(max)186939 nvarchar(max)187993 text187993 ntext TEXT blob.html STRING,CLOB,TEXT,CHARACTER LARGE OBJECT CLOB text datatype-character.html#DATATYPE-CHARACTER-TABLE TEXT LONG VARCHAR BLOB Character LOBs max size, bytes no limit 178158 storage-requirements.html 4 GB - 1 byte 1 000 000 000 limits.html#max_length about 2 GB about 1 GB datatype-character.html about 4 GB Binary LOBs BLOB(n) BLOB(n) BLOB SUB_TYPE BINARY BLOBLONG BYTE 188362 varbinary(max)187993 image BLOB(n)BINARY LARGE OBJECT blob.html BLOB(n) BLOB datatype-binary.html bytealo.html lo BLOB LONG VARBINARY BLOB Binary LOBs max size, bytes no limit 178158 storage-requirements.html 4 GB - 1 byte 1 000 000 000 limits.html#max_length about 4 GB about 2 GB |} Notes: