PDA

View Full Version : Issues when binding a QByteArray as a BLOB in MySQL



agerlach
22nd October 2010, 19:33
When I bind a QByteArray to a BLOB in MySQL the resulting entry is always limited to 64KB. Is this a server or client limitation?


Added after 10 minutes:

I love how I wrestled with this all morning and once I finally decide to post my question on the forum I come up with the answer myself about 30 seconds later. :p

BLOBs are restricted to 64KB, MEDIUMBLOBS to 16MB and LARGEBLOBS to 2GB. I switch the data type in the database to LARGEBLOB and everything is now working.

Thanks.

wysota
23rd October 2010, 13:43
No problem :)