Bug #18433: Integer values are broken when retrieved through a ODBC connection

From: Date: Fri, 19 Jul 2002 10:07:36 +0000
Subject: Bug #18433: Integer values are broken when retrieved through a ODBC connection
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-14619@lists.php.net to get a copy of this message
From: dgollub@lis-ag.de Operating system: Windows 2000 Server PHP version: 4.1.2 PHP Bug Type: ODBC related Bug description: Integer values are broken when retrieved through a ODBC connection Hello, sorry, if this bug is already somewhere in the list, but I didn't found it than... briefly my config: PHP-Version: 4.1.2 (installed as CGI) Webserver: IIS 5 on a Win2k Server, SP2 installed ODBC-Driver Version for MS-SQL Server: 3.70.09.61 And here is the BUG: When I try to get timestamp values from a MSSQL 2000 server over ODBC via PHP, then I get these results (using var_dump()): ["session_start"]=> string(17) "1.027.070.2tø" ["session_time"]=> string(17) "1.027.071.2tø" session_start and session_time are int(4) fields within the database! The QueryAnalyser from MS returns the correct value "972086460" or something similar. Same for the user_id (int(4) in the DB): ["user_id"]=> string(5) "1,00" So, I wonder if this a pure ODBC bug or a PHP(-ODBC) bug or what is it? Any ideas? I'm just trying to get the good old phpBB forum to work in our local intranet. PS: I know my English suxx... Shit happens. ;-) -- Edit bug report at http://bugs.php.net/?id=18433&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=18433&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=18433&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=18433&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=18433&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=18433&r=support Expected behavior: http://bugs.php.net/fix.php?id=18433&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=18433&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=18433&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=18433&r=globals

« previous php.bugs (#14619) next »