Bug #15819: mysql_fetch_array doesn't return full contents of a varchar column

From: jh@lohi.eng.song.fi Operating system: linux 2.2.19 PHP version: 4.1.2 PHP Bug Type: MySQL related Bug description: mysql_fetch_array doesn't return full contents of a varchar column i have a table called LOCATION that has a varchar(100) type field called contact. when i make a query select contact from LOCATION where (uri LIKE "%901%") using mysql-navigator, i correctly get the whole string contents of the contact field: <sip:0333983901@195.10.149.27;user=phone;transport=udp>;expires="Fri, 01 Mar 2002 18:37:13 GMT but when i make the same query from php, and then apply to the result mysql_fetch_array($result), the contact sting is missing the first part of the string: <sip:0333983901@195.10.149.27;user=phone;transport=udp> and only contains the remaining part: Array ( [0] => ;expires="Fri, 01 Mar 2002 18:37:13 GMT" [contact] => ;expires="Fri, 01 Mar 2002 18:37:13 GMT" ) why is the first part between <>s missing? is this a bug or should i do something special because of the <>s? my php is debian php4 4.1.2-1 and my php-mysql is debian php4-mysql4.1.1-2. -- juha -- Edit bug report at http://bugs.php.net/?id=15819&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=15819&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=15819&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=15819&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=15819&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=15819&r=support Expected behavior: http://bugs.php.net/fix.php?id=15819&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=15819&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=15819&r=submittedtwice