#26828 [Opn->Asn]: queried bit fields are space-padded

ID: 26828 Updated by: sniper@php.net Reported By: jim dot hatfield at insignia dot com -Status: Open +Status: Assigned Bug Type: Sybase (dblib) related Operating System: FreeBSD 4.5-RELEASE PHP Version: 4.3.4 -Assigned To: +Assigned To: iliaa New Comment: See bug #25777 (assigning this to Ilia who removed this trimming from ext/sybase) Previous Comments: ------------------------------------------------------------------------ [2004-01-07 09:19:37] jim dot hatfield at insignia dot com Description: ------------ Retrieve one row from a Sybase database using DB-Lib and Freetds 0.61_1. "manager" is a smallint and "ts_admin" is a "bit". The first record has field values 1 and 0 for these fields respectively. I did a "portupgrade lang/php4" between the two runs so I know the only thing which changed was the PHP version. Reproduce code: --------------- $db = sybase_connect($server, $user, $pass); sybase_select_db($dbname, $db); res = $sybase_query("select manager, ts_admin from employees", $db) $row = sybase_fetch_row($res); echo "Manager = \"$row[0]\"\n"; echo "TS_Admin = \"$row[1]\"\n"; Expected result: ---------------- 4.3.3 returns: Manager = "1" TS_Admin = "0" Actual result: -------------- 4.3.4 returns: Manager = "1" TS_Admin = "0 " note the space padding. When tested in an if this returns TRUE when without the padding it is FALSE ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=26828&edit=1