Bug #53966 [NEW]: convertion NULL value in integer 0
From:
Operating system: Windows XP SP3
PHP version: 5.2.17
Package: MSSQL related
Bug Type: Bug
Bug description:convertion NULL value in integer 0
Description:
------------
---
From manual page: http://www.php.net/function.mssql-fetch-object#Valeurs
de
retour
---
System Windows NT BLISS 5.1 build 2600
Build Date Jul 21 2010 18:41:42
Configure Command cscript /nologo configure.js "--enable-snapshot-build"
"--enable-debug-pack"
"--with-snapshot-template=d:\php-sdk\snap_5_2\vc6\x86\template"
"--with-php-build=d:\php-sdk\snap_5_2\vc6\x86\php_build"
"--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared"
"--with-oci8=D:\php-sdk\oracle\instantclient10\sdk,shared"
"--without-pi3web"
Server API Apache 2.0 Handler
Virtual Directory Support enabled
Configuration File (php.ini) Path C:\WINDOWS
Loaded Configuration File C:\WINDOWS\php.ini
Scan this dir for additional .ini files (none)
additional .ini files parsed (none)
PHP API 20041225
PHP Extension 20060613
Zend Extension 220060519
Debug Build no
Thread Safety enabled
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams php, file, data, http, ftp, compress.zlib, zip,
sqlsrv
Registered Stream Socket Transports tcp, udp
Registered Stream Filters convert.iconv.*, string.rot13, string.toupper,
string.tolower, string.strip_tags, convert.*, consumed, zlib.*
Test script:
---------------
in MS SQL server 2000 :
Foo bit null authorised
Bar integer null authorised
select Foo , Bar from BF
result in MS SQL:
<NULL>,<NULL>
in php you have 0,NULL
a bit at NULL is automaticly convert to 0
Expected result:
----------------
you must have
result in MS SQL:
<NULL>,<NULL>
in php you have NULL,NULL
--
Edit bug report at http://bugs.php.net/bug.php?id=53966&edit=1
--
Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=53966&r=trysnapshot52
Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=53966&r=trysnapshot53
Try a snapshot (trunk): http://bugs.php.net/fix.php?id=53966&r=trysnapshottrunk
Fixed in SVN: http://bugs.php.net/fix.php?id=53966&r=fixed
Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=53966&r=needdocs
Fixed in release: http://bugs.php.net/fix.php?id=53966&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=53966&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=53966&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=53966&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=53966&r=support
Expected behavior: http://bugs.php.net/fix.php?id=53966&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=53966&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=53966&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=53966&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=53966&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=53966&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=53966&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=53966&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=53966&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=53966&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=53966&r=mysqlcfg
Thread (3 messages)
- julien dot fabre at pg-soft dot fr