PHP 4.0 Bug #10192: sybase_query with sybase_fetch_row displays real data type incorrectly

From: dave.berndt@frco.com Operating system: Linux Mandrake (redhat) 7.0 PHP version: 4.0.3pl1 PHP Bug Type: Sybase (dblib) related Bug description: sybase_query with sybase_fetch_row displays real data type incorrectly Queries that produce incorrect data is random, but will consistently happen within a particular query. In one case, the last value of a fetched row (a real), in the last row was "1" in the database, but the returned array always displayed "0". In another case, a value (a real) in the middle of the returned array in the database was supposed to be "65000" but the fetched array contained "0". In both cases I copied the query from the code EXACTLY and ran it in isql and those results were correct. So the errors are occuring somewhere in php land. This error seems serious since no errors/messages are produced, but the data displayed is incorrect. Sybase's real data type is machine-dependent, and my database is on a Solaris system. But if isql on my linux php machine fetches data correctly, I would expect php to be able to do the same. Complied with: --with-apxs=/usr/sbin/apxs --with-sybase=/opt/sybase --without-mysql --with-layout=RedHat --enable-shared=max -- Edit Bug report at: http://bugs.php.net/?id=10192&edit=1