#38231 [Opn->Fbk]: mysqli_stmt_bind_param incorrect values

ID: 38231 Updated by: tony2001@php.net Reported By: anton at ht-systems dot ru -Status: Open +Status: Feedback Bug Type: MySQLi related Operating System: Linux PHP Version: 5.1.4 New Comment: You don't need to install it, you just need to build and test it, that doesn't required any actions regarding the existing PHP installation. Previous Comments: ------------------------------------------------------------------------ [2006-07-27 09:23:38] anton at ht-systems dot ru I upgrade mysql server & client to 4.1.20 the same problem. Also it would not be desirable to pass on 5.2 yet, it is stable? ------------------------------------------------------------------------ [2006-07-27 08:41:19] tony2001@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.2-win32-latest.zip Not reproducible here. Both MySQL server & client are 4.1.18. ------------------------------------------------------------------------ [2006-07-27 08:21:20] anton at ht-systems dot ru Description: ------------ web server placed on 32bit linux server with php 5.1.4 and mysql 4.1.18 client. If i using database on 32bit linux server all work correctly, but if using 64bit lunix server after execute statement in database placed incorrect values. in database i see: instead of 19 I see 196864 instead of "RRRRRRRRR" I see "RRRRRRRRRюЂdef
??юЂ
юb7_optЂµa «*?µa «*ђµa «*?µa " Reproduce code: --------------- $mys = new mysqli($mysql_['host'], $mysql_['username'], $mysql_['password'], $mysql_['database']); $qu_insert = "INSERT INTO assort (ind, articul) VALUES (?, ?)"; $stmt = $mys->prepare($qu_insert); $ind = 19; $articul = "RRRRRRRRR"; $stmt->bind_param("is", $ind, $articul); $stmt->execute(); $stmt->close(); ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=38231&edit=1