blob space question

Posted in 2004

Topics: Storage & Space Management, Data Types & Schema Design

Nathan Hattersley — 11 May 2004 17:00:11 -0700 — source: Usenet: comp.databases.informix

I have never used the blob data type before and I have a question. After setting up a test table with a column defined as BLOB, I have managed to successfully insert into and retrieve data from this table. My question is probably pretty straight forward, but, where is the data being stored? I have not specified the blobspace to be used for storage. Have I done something wrong? Thanks in advance, Nathan Hattersley mailto:nathan.hattersley@sensis.com.au

↪ replying to Nathan Hattersley

Paul Watson — Wed, 12 May 2004 07:21:15 +0100 — source: Usenet: comp.databases.informix

If you didn't use 'put' for the column then the data will be with the table. Normally you would create a separate blobspace and put the data in that. You could run an alter table to move it. Nathan Hattersley wrote: > > I have never used the blob data type before and I have a question. > After setting up a test table with a column defined as BLOB, I have > managed to successfully insert into and retrieve data from this table. > My question is probably pretty straight forward, but, where is the > data being stored? I have not specified the blobspace to be used for > storage. Have I done something wrong? > > Thanks in advance, > > Nathan Hattersley > mailto:nathan.hattersley@sensis.com.au -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

Glossary

blobspace