blob column size

Posted in 2006

MICHAEL FAVOLE — Thu, 12 Jan 2006 18:10:16 — source: IIUG Forums & Mailing Lists

Does anyone know the size in bytes of a BLOB column type? I know that for dumb blobs, the BYTE type requires 56 bytes. But I can't find any documentstion as to the size of the BLOB data type for smart blobs. Thanks Mike

↪ replying to MICHAEL FAVOLE

AJAY GUPTA — Fri, 13 Jan 2006 01:18:24 — source: IIUG Forums & Mailing Lists

Size of blob/clob column is 76 bytes. You can create a table with blob a column and check the rowsize of the table using oncheck -ps output.