sybase numeric garbage
| From: | Harold | Date: | Thu, 04 Nov 1999 18:33:35 +0000 |
| Subject: | sybase numeric garbage | ||
| Groups: | php.version4 | ||
| Request: | Send a blank email to php-version4+get-5892@lists.php.net to get a copy of this message | ||
i have been developing with php4b2 and have noticed that after a numeric
field from a sybase database is retrieved, it has garbage after it.. this
also happens with the latest(04/10) cvs build..
here is an example query:
<?
sybase_connect("hserver","sa","") or die("Unable to connect to
server!");
@sybase_select_db("hdb") or die("Unable to connect to database!");
$query = sybase_query("select field_id from FIELD where fieldgroup_id =
1");
while ($row = sybase_fetch_array($query)) {
?>
<tr>
<td align=right valign=middle><font size=-1 face="verdana,
arial, helvetica"><b><? echo $row[0]; ?></b></font></td>
</tr>
<?
}
?>
this outputs:
<tr>
<td align=right valign=middle><font size=-1 face="verdana,
arial, helvetica"><b>100.0 </b></font></td>
</tr>
<tr>
<td align=right valign=middle><font size=-1 face="verdana,
arial, helvetica"><b>101.0 </b></font></td>
</tr>
<tr>
<td align=right valign=middle><font size=-1 face="verdana,
arial, helvetica"><b>102.0 </b></font></td>
</tr>
<tr>
<td align=right valign=middle><font size=-1 face="verdana,
arial, helvetica"><b>103.0 8 È </b></font></td>
</tr>
if i use sprintf, a clear return of 100, 101, 102, and 103 are given as
output.. but it is only a temporary solution..
is this a bug? or am i doing something wrong?
thanks for your time
harold