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 Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
7 + 32 = ?
Subscribe to this entry?

 
 [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

Add a Patch

Pull Requests

Add a Pull Request

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 Apr 25 20:01:45 2024 UTC