#5954 [Opn->Bgs]: Informix can't reliably figure if a text result column is NULL

ID: 5954 Updated by: jani@php.net Reported By: mlemos at acm dot org -Status: Open +Status: Bogus Bug Type: Feature/Change Request Operating System: Linux RH 6 PHP Version: 4.0 Latest CVS (04/08/2000) Assigned To: danny New Comment: Informix is now in PECL. Please submit any feature requests here: http://pecl.php.net/package/informix 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 at acm dot 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. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=5954&edit=1