longblob column in MySQL database table
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I am using DataSet to insert a data row which contains a 6MByte binary file in "Data" column. According to the MySQL manual for 4.0, I define the "Data" column as "longblob", which suppose to store up to 4GByte file. But it just doesn't work. With the exact same code, if my data is less than 100KByte, it works fine. Can anybody tell if I have to config anywhere else to make this work? From MySQL 4.0, the maximum allowed length of LONGBLOB columns depends on the configured maximum packet size in the client/server protocol and available memory. I just wonder what "client/server protocol" refers to? How can I figure out the maximum packet size?