>> 1 Mb in Mysql

[Anon]

Can't add more than 1Mb binary data in blob colum.
Mysql 3.22.
Apache 1.3
Win NT

[Anon]

So? Whats the fuss about? Try another field type like longblob, which is a much bigger field to insert data.

See http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Storage_requirements for more information about storage requirements.

[Anon]

I was meen longblob. In that case MySql would
give me an error. In my case silent.

[Anon]

Check out the max_allowed_packet by typing mysqld --help

This is maximum data you can store in one field. See section 10 in the MySQL manual about changing this to allow bigger fields.

Matt B

[Anon]

max_allowed_packet set to 8 mb| tmp_table_size is ok

[Anon]

Sorry, I'm out of answers on this one! That's strange.

[Anon]

How are you uploading the data into the fields?

[Anon]

 $picture=StripSlashes($picture);

 $fp=fopen($picture,'r');
 $pic_data=addslashes(fread($fp,filesize($picture)));

$q="insert into pictures(picture_id,binary_data,room_id,start_image,description,photograph,user,type) values ($ress,'$pic_data',$roomid,$id,'$description','$photogr','$user',2)";
if (!mysql_query($q)) echo mysql_error();echo "==";echo mysql_errno();