note 96850 modified in mysqli-stmt.bind-param by danbrown

I did a prepared statement for inserting in a simple table - images ( blob ) and their unique identifiers ( string ). All my blobs have smaller sizes than the MAX-ALLOWED-PACKET value. I've found that when binding my BLOB parameter, I need to pass it as a STRING, otherwise it's truncated to zero length in my table. So I have to do this: <?php $ok = $stmt->bind_param( 'ss', $id, $im ) ; ?> --was-- I did a prepared statement for inserting in a simple table - images ( blob ) and their unique identifiers ( string ). All my blobs have smaller sizes than the MAX-ALLOWED-PACKET value. I've found that when binding my BLOB parameter, I need to pass it as a STRING, otherwise it's truncated to zero length in my table. So I have to do this: $ok = $stmt->bind_param( 'ss', $id, $im ) ; http://php.net/manual/en/mysqli-stmt.bind-param.php