ID: 14665 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Feedback Bug Type: Informix related Operating System: Linux 2.2.x PHP Version: 4.1.0 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2002-09-17 15:48:21] [EMAIL PROTECTED] //create connection $connection=ifx_connect("audit@ifmx00296") or die("Couldn't create connection."); //create SQL statement $sql="select * from pjktest where col1 matches '$hname'"; //execute SQL query and get result $sql_result=ifx_query($sql,$connection) or die("Couldn't execute query"); //format result in HTML table ifx_htmltbl_result($sql_result,"border=10"); Using Apache 1.3.22,PHP 4.2.2,Informx 9.21.UC2,ESQL 9.40,AIX 4.3.3.0. col1 type lvarchar is only column in table, query fails when row is NOT NULL This Bug was closed as fixed in PHP 4.0.0 but I still have the problem. ------------------------------------------------------------------------ [2002-08-17 15:38:59] [EMAIL PROTECTED] If you need more information please ask instead of closing this bug. LVARCHAR is a Informix text field type of unspecified length similar ro MySQL TEXT field type. To reproduce this bug follow these steps: - Create a table with a LVARCHAR field. - INSERT a row with some data in that field. - SELECT that row. - Use ifx_fetch_row to retrieve the field value. When you access to the field value you will see warnings because the string value that is retrieved is not a NUL terminated string. ------------------------------------------------------------------------ [2002-08-16 12:34:18] [EMAIL PROTECTED] Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. ------------------------------------------------------------------------ [2001-12-22 22:48:21] [EMAIL PROTECTED] Ditto. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=14665&edit=1