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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: rawlingsnco at geocities dot com
New email:
PHP Version: OS:

 

 [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: Sat Dec 21 17:01:58 2024 UTC