I Give Up: Data too long for column 'Image' at row 1

[smays]

Okay, I give up. How does one place more than 50kBytes in a modern MySQL database (5.1.48-community) programmatically?

I have tried increasing the max_allowed_packet to 16M:

[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306
max_allowed_packet = 16M

Here is how the table is created:

CREATE TABLE `image_table` (
  `ImageID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ImagePathNFilename` varchar(256) NOT NULL,
  `Image` blob NOT NULL,
  PRIMARY KEY (`ImageID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1

Here is the query I am attempting to use:

char *cQueryStatement = "INSERT INTO image_table(ImagePathNFilename, Image) VALUES('%s', '%s')";

I don't get it. What is the REAL size limit of BLOB fields? I get the same response whether I am working over a network as I do as localhost. I have used commercial libraries and I get the same response. I am confident the problem is with MySQL - more specifically with some setting I would have never in a million years guessed.

If you have any clue as to what the problem is, please, let me know.

Thanks,
Steve.

 

[smays]

Well, I stumbled across the answer at the following website:

http://stackoverflow.com/questions/624337/adding-image-to-a-database-in-java

Apparently, according to the above link, BLOB ==> 64kBytes, MEDIUMBLOB == > 16MBytes

Steve.