|  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
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:
Solve the problem:
28 + 1 = ?
Subscribe to this entry?

 [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')){
        $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 for Linux, Apache/SSL 1.3.3 and PHP 3.0.5


Add a Patch

Pull Requests

Add a Pull Request


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 Mar 02 00:01:28 2024 UTC