Bug #40394 [Asn->Opn]: mssql_bind() converts empty strings to null

Edit report at https://bugs.php.net/bug.php?id=40394&edit=1 ID: 40394 Updated by: kalle@php.net Reported by: rnerovich at gmail dot com Summary: mssql_bind() converts empty strings to null -Status: Assigned +Status: Open Type: Bug Package: MSSQL related Operating System: XP/2003 server PHP Version: 5.2.0 -Assigned To: fmk +Assigned To: Block user comment: N Private report: N Previous Comments: ------------------------------------------------------------------------ [2008-03-04 16:22:36] alexr at oplot dot com Guys, I was fix (temporarily) this bug, please see the http://bugs.php.net/bug.php?id=44325 ------------------------------------------------------------------------ [2007-06-21 10:12:22] smargroth at hotmail dot com I have the same problem and it makes me a headache all the time. This bug is very annoying, as empty string is normal and valid value, and is different from NULL value. I have non-NULL-able columns, and I cannot insert empty strings because of this stupid bug. The only workaround is to make NULL-able columns, but then I could not distinguish between omitted (NULL) or valid empty string. ------------------------------------------------------------------------ [2007-02-07 23:27:04] tony2001@php.net Assigned to the maintainer. ------------------------------------------------------------------------ [2007-02-07 23:19:24] rnerovich at gmail dot com Just tried the new snapshot with the same result. 885: [02/07] [17:17:30] *** array ( 0 => 'ükÁ#ðÌæM†TèÇS±í°', 'ucode' => 'ükÁ#ðÌæM†TèÇS±í°', 1 => NULL, 'phone' => NULL, 2 => NULL, 'account' => NULL, 3 => '423998059-130628001', 'ealoc' => '423998059-130628001', 4 => '2007-02-07 17:17:21', 'time' => '2007-02-07 17:17:21', 5 => 'g÷r}Q\'N°¥@Iñ*¬', 'recid' => 'g÷r}Q\'N°¥@Iñ*¬', 6 => NULL, 'prbstr' => NULL, ) ------------------------------------------------------------------------ [2007-02-07 22:48:56] tony2001@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.2-win32-latest.zip ------------------------------------------------------------------------ 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 https://bugs.php.net/bug.php?id=40394 -- Edit this bug report at https://bugs.php.net/bug.php?id=40394&edit=1