Page 1 of 1

SetDatabaseBlob() truncates data

Posted: Thu Jun 09, 2011 5:42 pm
by UrgentKettle
When using the ODBC database connection and SetDatabaseBlob(), if the blob data to be inserted is greater than 65535 bytes the remainder gets truncated. When selecting the data back from the DB the length of the blob data is 65535 bytes.

Inserting data that is less than 65536 works fine.

MySQL ODBC 5.1 Driver

Re: PB4.51 - SetDatabaseBlob() truncates data

Posted: Fri Jun 10, 2011 9:42 am
by UrgentKettle
:oops:

Seems that this is a MySQL limit and NOT an issue with PB.

RTFM.... RTFM....

Use LONGBLOB column type instead of BLOB and it all works fine :D

Re: PB4.51 - SetDatabaseBlob() truncates data

Posted: Fri Jun 10, 2011 12:46 pm
by shadow
UrgentKettle wrote::oops:
...
RTFM.... RTFM....
...
me, too :mrgreen: