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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
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

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-2021 The PHP Group
All rights reserved.
Last updated: Fri Mar 05 20:01:24 2021 UTC