ID: 35337 User updated by: bill dot finn at sellingsource dot com Reported By: bill dot finn at sellingsource dot com -Status: No Feedback +Status: Closed Bug Type: MySQLi related Operating System: Gentoo 2.6.9 PHP Version: 6CVS-2005-11-19 (snap) New Comment:
tested with 2005-11-29, works. Previous Comments: ------------------------------------------------------------------------ [2005-11-30 01:00:10] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, 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". ------------------------------------------------------------------------ [2005-11-22 22:31:31] [EMAIL PROTECTED] 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 ------------------------------------------------------------------------ [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
