ID: 28204 Updated by: php-bugs@lists.php.net Reported By: johann at infomaniak dot ch -Status: Feedback +Status: No Feedback Bug Type: Sybase (dblib) related Operating System: Linux PHP Version: 4.3.6 Assigned To: fmk New Comment:
No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". Previous Comments: ------------------------------------------------------------------------ [2005-03-25 01:43:42] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ [2004-07-27 23:11:40] fred at tc dot df dot gov dot br this patch doesn't resolve the problem 100%. this line: if ($row[Relationship]==1) returns false on php>=4.3.4, true on others. the field Relationship on mssql 6.5 is tinynit ------------------------------------------------------------------------ [2004-04-28 14:01:12] johann at infomaniak dot ch Description: ------------ The return value is the real value + a lot of space character (it is converted to a string with a constant length) maybe the problem come from freetds dbconvert. I have this problem since php 4.3.4 and in php 4.3.4 I applyed the following patch. diff -ruP php-4.3.4/ext/sybase/php_sybase_db.c php-4.3.4.patched/ext/sybase/php_sybase_db.c --- php-4.3.4/ext/sybase/php_sybase_db.c 2003-10-16 06:24:04.000000000 +0200 +++ php-4.3.4.patched/ext/sybase/php_sybase_db.c 2004-01-29 11:51:41.000000000 +0100 @@ -680,6 +680,7 @@ switch (column_type) { + case SYBBIT: case SYBINT2: case SYBINT4: { Z_LVAL_P(result) = (long) anyintcol(offset); @@ -893,6 +894,7 @@ case SYBINT4: case SYBFLT8: case SYBREAL: + case SYBBIT: result->fields[i].numeric = 1; break; case SYBCHAR: Expected result: ---------------- an integer for example 0 Actual result: -------------- a string with constant length for example "0 " ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=28204&edit=1