php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #524 Only first 4 digits of large number returned from database
Submitted: 1998-07-08 15:07 UTC Modified: 1998-07-12 17:39 UTC
From: bdwheele at indiana dot edu Assigned:
Status: Closed Package: Sybase (dblib) related
PHP Version: 3.0 Final Release OS: Solaris
Private report: No CVE-ID: None
 [1998-07-08 15:07 UTC] bdwheele at indiana dot edu
Sample code:

$xhandle=sybase_connect("xx","xx","xx");
sybase_query("use icis98",$xhandle);
$query=sybase_query("select nickname,id from dcarr.links",$xhandle);
print "<TABLE BORDER>\n";
while($row=sybase_fetch_row($query)) {
	print "<TR><TD>".join($row,"<TD>")."</TR>\n";
}
print "</TABLE>\n";

Output:

Super Cool Welder Stuff		21
 asdf				14
 cloverdale school		8999


The table, however, has the value of 899916014 for the id of 'cloverdale school'.  The number is really being stored, because it shows up in isql.

The 'id' column is an int, size 4, precision 10.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1998-07-12 17:39 UTC] zeev
Fixed (CVS / 3.0.2)
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Dec 03 23:01:31 2024 UTC