Bug #18433: Integer values are broken when retrieved through a ODBC connection
| From: | dgollub at lis-ag dot de | 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