Re: PHP 4.0 Bug #5954 Updated: Informix can't reliably figure if a text result column is NULL

Hello Bug, On 21-Nov-00 06:02:29, you wrote: >ID: 5954 >Updated by: sniper >Reported By: mlemos@acm.org >Status: Feedback >Bug Type: Feature/Change Request >Assigned To: danny >Comments: >Is this report still valid? Yes, there is still no way to figure if an result column has a real NULL or something else (empty string or NULL string) that may be confused with it. I reenforce my suggestion that somebody make ifx_fetch_row works like Oracle oci_fetch_row where NULL positions not contain anything. This behaviour could be activated by a new function so developers could use function_exists() to verify if the behaviour is available in the new version. >Previous Comments: >--------------------------------------------------------------------------- >[2000-08-04 23:13:22] danny@php.net >Seems a reasonable request. >Introduce the PHP4 notion of "NULL" values for variables? >if (ifx_hasnulloption()) { > ifx_nullformat(2); >} >Or do you prefer your proposal ? >??? >Danny >--- > >--------------------------------------------------------------------------- >[2000-08-04 17:22:50] mrobinso@php.net >Change to feature/change request. >--------------------------------------------------------------------------- >[2000-08-04 08:18:44] mlemos@acm.org >There is the ifx_nullformat to tell wether NULL are returned as empty >strings or a string that has the text "NULL" in it. Either forms can be >valid result values for character string result columns. There needs to >be a better solution. >Suggestion: make Informix support work more like Oracle support that >optionally does not set the entries of the result row array returned by >ifx_fetch_row. >This could be implemented with a new function for instance named >ifx_returnnullcolumns that would take an argument that would set a an >boolean option. null columns would only be returned if this option is true >and that would be the default value to remain compatible with the current >PHP-Informix API. >Adding this new function would be a better solution than adding an extra >mode option to ifx_nullformat because it would be easier detect if this >option is available using the function_defined() function. >--------------------------------------------------------------------------- >Full Bug description available at: http://bugs.php.net/?id=5954 Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --