#35337 [Opn->Fbk]: prepare update into longtext column broken

ID: 35337 Updated by: tony2001@php.net Reported By: bill dot finn at sellingsource dot com -Status: Open +Status: Feedback Bug Type: MySQLi related Operating System: Gentoo 2.6.9 PHP Version: 6CVS-2005-11-19 (snap) New Comment: Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2005-11-22 19:43:44] bill dot finn at sellingsource dot com Description: ------------ Performing an update into a non-null longtext column using prepare syntax. Example code works in php 5.0.x. Upgraded to 5.1.x and it started entering variations of empty strings, 0, or 0000-00-00 depending on how much data I was trying to enter. In a test that allows null values, it enters null. (mysql 5.0.13 && mysql 5.0.15) Reproduce code: --------------- CREATE TABLE test (col1 longtext not null); <?php $data = "whatever, some string"; $mysqli = new mysqli( HOST, USER, PASS, DB, PORT ); $query = "INSERT INTO test SET col1 = ?"; $prepared = $mysqli->prepare( $query ); $prepared->bind_param('s', $data ); $prepared->execute(); $prepared->close(); ?> Expected result: ---------------- contents of $data inserted into col1 of table. Actual result: -------------- SELECT col1 FROM test shows one of three things: 0000-00-00 0 empty string ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35337&edit=1