RE: Couldn't save binary BLOB object more than 38KB

I think the idea is that you can call AppendChunk multiple times with a smallish buffer to build up the very large object.

I've not actually used it on Ingres but only on SQL Server and that's how it works there but do actually use chunk size of 2Mb.

We looked at Ingres' blob handling but performance seemed to be eratic, sometimes a run inserting 10 blobs all the same size took 5 seconds and sometimes it took minutes to complete. There was no other activity or locks in the DBMS and so we found this very strange and decided to go with SQL Server instead!
-----Original Message-----
From: tongpran_at_hotmail.com [mailto:tongpran_at_hotmail.com] Sent: 31 July 2002 06:05
To: info-ingres_at_ams.org
Subject: Couldn't save binary BLOB object more than 38KB

I have defined one table with one column the data type is "long byte".  By using ADO data access method with "AppendChunk", I couldn't insert the binary data more than 38K byte in this "long byte" column. Also, the CA-Ingres ODBC driver showed me the error message as below :- Run-time error '-2147467259(80004005)': [CA][Ingres ODBC Driver] String data right truncation.

However, below 38K byte binary data. This OpenIngres 2.0 can accept it. We are using OpenIngres 2.0 on Solaris platform and this program is written by Visual Basic.

Any help ????????

Thanks... Received on Wed Jul 31 2002 - 10:25:41 CEST