[PHP-DEV] Bug #524: Only first 4 digits of large number returned from database From: bdwheele <email protected>
Date: 07/08/98

From: bdwheele <email protected>
Operating system: Solaris
PHP version: 3.0 Final Release
PHP Bug Type: Sybase related
Bug description:
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.