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
SetDatabaseBlob() truncates data
-
UrgentKettle
- User
- Posts: 12
- Joined: Thu Jan 27, 2011 12:25 pm
Re: PB4.51 - SetDatabaseBlob() truncates data
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
Re: PB4.51 - SetDatabaseBlob() truncates data
me, tooUrgentKettle wrote:
...
RTFM.... RTFM....
...
ThinkPad T61 | PureBasic 4.51 | Windows 7 (32) | Kubuntu 11.10 (64) | Syllable (32)