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

From: andrewt@weekendhosting.com Operating system: Win2000 / Unix PHP version: 4.2.1 PHP Bug Type: MySQL related Bug description: mysql_query seems to strip trailing spaces from variables $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 bug report at http://bugs.php.net/?id=17907&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=17907&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=17907&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=17907&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=17907&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=17907&r=support Expected behavior: http://bugs.php.net/fix.php?id=17907&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=17907&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=17907&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=17907&r=globals