ID: 41539 User updated by: phpbug dot 41539 at sub dot noloop dot net -Reported By: frode at coretrek dot com +Reported By: phpbug dot 41539 at sub dot noloop dot net Status: Assigned Bug Type: MSSQL related Operating System: Linux and win32 PHP Version: 5.2.5 Assigned To: fmk New Comment:
Changing emails, please ignore this comment. Previous Comments: ------------------------------------------------------------------------ [2007-11-15 15:33:27] frode at coretrek dot com The previous comment was a bit imprecise. I compiled FreeTDS from CVS tag BRANCH0_64 as of today, not from freetds-0.64.tar.gz+post64.diff.gz. ------------------------------------------------------------------------ [2007-11-15 15:31:16] frode at coretrek dot com I compiled (freetds 0.64 + post64.diff.gz) and then recompiled my (unmodified) php 5.2.5 using "--with-mssql=/path/to/the/freetds/installation", and whatever you did in post64.diff.gz seems to fix the problem. The test case in my original submission now prints: array(3) { ["id"]=> int(1) ["txt"]=> string(0) "" ["txtmax"]=> string(0) "" } array(3) { ["id"]=> int(2) ["txt"]=> NULL ["txtmax"]=> NULL } as expected. Thank you very much! Is there a timeline/ETA for the next stable release of FreeTDS (0.65)? Also, if any php developers are reading this: It would be great if the win32 binary distribution of PHP could be compiled and linked with FreeTDS instead of the Microsoft DBLIB libraries :) ------------------------------------------------------------------------ [2007-11-15 14:11:43] freddy77 at gmail dot com I'm a FreeTDS developer. There was a problem with (n)text and (n)varchar(max), not with (n)varchar (these types are blobs). For empty blobs pointer from dbdata was NULL. I fixed the problem in CVS HEAD and 0.64 branch. You can find cumulative post 0.64 patch at http://freetds.sourceforge.net/post64.diff.gz, change is at http://freetds.cvs.sourceforge.net/freetds/freetds/src/dblib/dblib.c?r1=1.244.2.3&r2=1.244.2.4 (similar change for CVS head). bye freddy77 ------------------------------------------------------------------------ [2007-10-19 08:43:59] frode at coretrek dot com Is there a chance to get a fix for this in before 5.2.5? ------------------------------------------------------------------------ [2007-08-13 08:19:34] frode at coretrek dot com Is there a chance to get a fix for this in before 5.2.4? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/41539 -- Edit this bug report at http://bugs.php.net/?id=41539&edit=1