SQL 32k blob size limit on read?

Colin Fraser

Delphi Developer

Fri, 11 Jul 2003 19:56:37 GMT

SQL 32k blob size limit on read?

I am using Delphi 5.0 to access a Postgresql database. I am able to write
blob fields > 32K and can verify that they made it to PostGres OK. However
when I try to access them using BDE/ODBC/SQL only 32768 bytes max is ever
returned.

Can someone please help?

Regards,

Colin Fraser

Colin Frase

Delphi Developer

Fri, 11 Jul 2003 22:07:56 GMT

Re:SQL 32k blob size limit on read?

I dont know if my last posting got through. We found the solution in the
meantime. The BDE Administrator utility displays a maximum blob size setting
that seems to be defaulted at 32. Setting this higher cured the problem.

Regards,

Colin

Quote

"Colin Fraser" <CFra...@levelfour.com> wrote in message news:...
> I am using Delphi 5.0 to access a Postgresql database. I am able to write
> blob fields > 32K and can verify that they made it to PostGres OK. However
> when I try to access them using BDE/ODBC/SQL only 32768 bytes max is ever
> returned.

> Can someone please help?

> Regards,

> Colin Fraser

Other Threads

1. Read blob from a database > 32K size

2. 32K Blob limit on Sybase SQl Anywhere

3. Are ODBC Blobs limited to 32K?

4. 32K limit on Blob fields in Oracle

5. Blob 32k Limit in Builder 5 and MySql

6. MSAccess Blob field size can hold only 32k

7. Reading BLOB fields with more then 32K fails

8. BDE and SQL Server 32k limited.

9. BLOB-field bigger then 32K in a Sybase SQL Anywhere database

10. Blobs greater than 32K in SQL-Server 6.5/Delphi 3.0