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

ID: 5954 Updated by: sniper Reported By: mlemos@acm.org Status: Open Bug Type: Feature/Change Request Assigned To: danny Comments: Still valid. (and now I noticed this was a Feature req..) --Jani Previous Comments: --------------------------------------------------------------------------- [2000-11-21 04:02:29] sniper@php.net Is this report still valid? --------------------------------------------------------------------------- [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