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

Reply via email to