Bug #17907 Updated: mysql_query seems to strip trailing spaces from variables

ID: 17907 Updated by: cynic@php.net Reported By: andrewt@weekendhosting.com -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Win2000 / Unix PHP Version: 4.2.1 New Comment: Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. Previous Comments: ------------------------------------------------------------------------ [2002-06-21 13:37:37] andrewt@weekendhosting.com Further to this mysqlfront (which is presumably using the c++ mysql API can handle this trailing space no problem) ------------------------------------------------------------------------ [2002-06-21 13:34:25] andrewt@weekendhosting.com $myVar = 'SR4 1 '; $sql = "INSERT INTO myTable (myField) VALUES ('$myVar')"; echo $sql."<br>"; $result = mysql_query($sql); ----- I'm not so sure if this is a bug, but surely, it's not supposed to do this ?? Thanks ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=17907&edit=1