BLOB

AS/400 SQL BLOBS

I am trying to read data from a SQL table that contains a BLOB of 10MB.  Since the RPG field size is limited to 32KB, is this even possible? Software/Hardware used: AS/400SQL

Storing image in Oracle 9i

how to store and retrieve image having size more than 1 GB in oracle 9i

How Do I release unused space from a tablespace after dropping a blob table

I have a 30 GB BLOB table in a 162 GB tablespace. After I used the online table reorg to move this BLOB table and its BLOB index to another tablespace, Toad tells me that I have about 35 GB free. However, I can not reduce the size of this tablespace (i.e, resize the datafiles associated with this...

Notes rich text field to BLOB/Memo field in SQL Server using ADOdb

I have an agent that uses ADODB to connect and insert a row into a SQL Server database. I want to store the contents of the Body field in the memo (rich text) into a Memo field in the SQL Server database (or Blob field). I'm finding examples of reading this kind of data back into a Notes...

How to insert an image file into an Oracle 8i database?

Hi Experts, I am using forms&reports6i with the oracle 8i database. Now i want to insert a image file into the database and i want to access that in reports. I tried the insert statement but i couldn't. can anyone help me for inserting.

Using the BLOB datatype

IT HAS BEEN CLEARED THAT TO INSERT THE IMAGES INTO ORACLE DATABASE, A COLUMN WITH DATATYPE BLOB HAS TO BE CREATED IN THE TABLE, PLEASE TELL ME HOW TO INSERT AND RETRIEVE THE IMAGE INTO AND FROM THE DATABASE RESPECTIVELY. THANKS, SIMRAN.

DTS of TEXT to BLOB or CLOB

Is there a maximum size to DTS from text to a Blob or clob ?

Storing Binary Data

I've been in the process of reviewing the pros and cons of storing binary data (e.g. image files) either in blob fields in a database (presumably MySQL) vs. the filesystem of a server. I'm aware there are some concerns of security, but I'm mainly interested in performance at present. I could...

Storing BLOB to file through SQL Server 2005

I want to know how to Export BLOB data to a JPG File at the SQL Server end ... NOT USING C# or VB

BLOB Data move from Oracle 9i to Oracle 10g

I want to move BLOB data from oracle9i to oracle 10g through java application. I am getting following error : java.sql.SQLException: ORA-00942: table or view does not exist. Using JDK1.5 & ojdbc5.jar

Table partitioning, CLOB and BLOBs in DB2 9 LUW?

Hi all, My shop has decided that we will take advantage of DB29 table partitioning for some of our large tables. Some of these table have CLOB, LOB and BLOB columns. We intend to split the large tables across several storage objects. I am looking for someone who have done table partitioning and...