MySQL Bugs: #24429: blob data has been corrupted

Bug #24429	blob data has been corrupted
Submitted:	19 Nov 2006 15:06	Modified:	20 Dec 2006 15:24
Reporter:	[ name withheld ]	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.27	OS:	Windows (Windows XP SP2)
Assigned to:		CPU Architecture:	Any

Description:
I added the blog data (pdf, text, zip etc..) to longblob data type on MySQL server.
I got error message "data has corrupted" when I get the blob data from mysql query browser UI.

BTW, Mysql server 5.0.11 is fine.

How to repeat:
I'm using php 5 and apache 2.

Here is my PHP code.
<?php
global $fileUpload;
global $fileUpload_name;
global $fileUpload_size;
global $fileUpload_type;

$fileHandle = fopen($fileUpload, "r");
$fileContent = fread($fileHandle, $fileUpload_size);
$fileContent = addslashes($fileContent);

$query = "INSERT INTO tbl (data,data_filename,data_filetype) VALUE ('$fileContent', '$fileUpload_name','$fileUpload_type');

... query execute code...
?>

Thank you for a problem report. Please, send the results of:

SHOW CREATE TABLE tbl;

Please, send also your my.init file content. Check the results with mysql command line tool, not QB (it can be a separate QB bug).

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".