blobs <-> diskspace
I have a question regarding blob's.
If I have a table like below
CREATE TABLE test
(
num_1 INTEGER NOT NULL,
doc_1 TEXT,
doc_2 TEXT IN blob_dbs,
) IN data_dbs;
and inserts a number into num_1 and let doc_1 and doc_2 be empty.
Do doc_1 and doc_2 occupy any space when left empty (e.g. a page or a
zero length indication) ?
Please notice the difference between doc_1 and doc_2 before answering.
Thanks,
--
-------------------------------------------------------------------------
Soeren AErendahl Mikkelsen | LEC | Phone: (+45) 8621 4000
M.Sc.E.E. (computer vision) | Bytoften | room 4869
| DK-8240 Risskov |
System Engineer | Denmark | Email:sam@imagine.lec.dk
-------------------------------------------------------------------------