Re: using BLOB

Posted in 2000

Obnoxio The Clown — Tue, 12 Sep 2000 14:09:42 BST — source: Informix-list mailing list archive (1991-1998)

From: "Michael Lai" <mlai@cromwellmedia.co.uk> > >Do I need to create "sblobspace1" before I run this script? >If not, why? > >CREATE TABLE blade_content >( > content_name CHAR(32) NOT NULL , > content_data blob ,> >) put content_data in (sblobspace1) clob, surely? And no, you don't have to create sblobspace1, the engine will automatically read your mind to find out where you want to create it, how big you want it to be, the blobpage size, etc. Provided you have the Oracle MindReader DataBlade registered of course. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.