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
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: bdwheele at indiana dot edu
New email:
PHP Version: OS:

 

 [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: Thu Dec 05 10:01:32 2024 UTC