php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #9855 Return column data with correct type
Submitted: 2001-03-20 00:04 UTC Modified: 2001-06-30 15:25 UTC
From: ron dot baldwin at sourceprose dot com Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4.0.4pl1 OS: Windows 2000
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: ron dot baldwin at sourceprose dot com
New email:
PHP Version: OS:

 

 [2001-03-20 00:04 UTC] ron dot baldwin at sourceprose dot com
Suggestion:

Add new data retrieval functions (or extend mssql_fetch_array and mssql_fetch_row) to return each column in a type that matches the underlying database column type instead of the always as type string.  Also, return columns that are NULL as PHP's null type (instead of boolean/false).

Two questions - is this the proper place to submit suggestions, and if so should this also be submitted to the general 'database functions' category (I know PHP's ODBC functions exhibit the same behavior)?

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-06-30 15:25 UTC] fmk@php.net
Update to php4.0.6, and you will find what you are asking for.

The setting mssql.compatability_mode in php.ini can be used to specify how data are returned.

mssql.compatability_mode = Off Returns data as php types

mssql.compatability_mode = On Returns all data ass strings.
 [2003-05-30 06:58 UTC] slopez at patasoft dot com
I'm looking for a solution to the same problem but under ODBC. I'm using 4.3.1 but odbc_result keeps returning NULL field values as boolean(false).
Any directions will be appreciated.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 21 12:01:31 2024 UTC