BLOB SUB_TYPE 0

From: Vincent Nuijten <info_at_c-content.nl>
Date: Thu, 24 Jun 1999 16:04:16 +0200
Message-ID: <7kteem$jo4$2_at_zonnetje.NL.net>



hi,

i'm trying to create a column in a table with the following definition:
(i want to use this column for storing images)

type: BLOB SUB_TYPE 0
Size: 2147483647
Decimals: 0
Nulls: Yes
Sql type: -4

(the size doesn't really matter)

i only succeeded in creating a column by:

create table blobtable ( picture BLOB );

the definition of the picutre column is:

type: BLOB
Size: 4000
Decimals: 0
Nulls: Yes
Sql type: 1111

i can't store images in this column.

can some please help me with this?
(i now this is not an oracle-problem, but more a sql-problem)

thanks in advance,

vin Received on Thu Jun 24 1999 - 16:04:16 CEST

Original text of this message