php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #889 extraneaous character output w/ datetime columns.
Submitted: 1998-11-01 18:09 UTC Modified: 1999-11-05 03:54 UTC
From: rawlingsnco at geocities dot com Assigned:
Status: Closed Package: Sybase (dblib) related
PHP Version: 3.0.5 OS: Redhat Linux 5.1 / Linux 2.0.35
Private report: No CVE-ID: None
 [1998-11-01 18:09 UTC] rawlingsnco at geocities dot com
I am getting extraneaous characters appearing at the end of date fields when I connect and do a query from PHP3.

-------begin copy of results------

Mar 19 1972 12:00:00:000AM
Mar 14 1974 12:00:00:000AM
Dec 24 1995 12:00:00:000AMn
Feb 4 1998 12:00:00:000AM
Jun 4 1945 12:00:00:000AMl

-------end copy of results--------

Note the 'n' and the 'l' after the AM in the dates.  This is sometimes non-ascii characters also.  Those rows were not included in the sample because I wasn't sure if the characters would show up properly for you.  This seems to only occur with dates and only ever seems to be one character.

-------begin Sample Script--------
<?
if ($sybcon=sybase_connect('host','username','password')){
        sybase_select_db('database',$sybcon);
        $result=sybase_query("select DateField from Table",$sybcon);
        while ($row = sybase_fetch_array($result)){
                echo $row[DateField],'<BR>';
        }
}
?>
-------end Sample Script------------

configure options:
--with-sybase=/path/to/sybase --with-apache=/path/to/apache

I am using a generic php3.ini (the stock one in the distribution)

I am using the Sybase ASE 11.0.3.3 for Linux, Apache/SSL 1.3.3 and PHP 3.0.5

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1999-11-05 03:54 UTC] thies at cvs dot php dot net
fixed in cvs
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon Dec 30 14:01:28 2024 UTC