From: [EMAIL PROTECTED] Operating system: Windows 2000 Server PHP version: 4.0.6 PHP Bug Type: InterBase related Bug description: Bug with inserting NULLs using ibase_prepare()/ibase_execute() Environment: - Windows 2000 Server - Apache v1.3.20 (binaries from www.apache.org) - PHP v4.0.6 (binaries from www.php.net) - InterBase v6.0.0.627 (binaries from www.borland.com) 1. Let's create very simple database: ----------------------------------------------------------------- CREATE DATABASE 'c:\db\test.gdb' USER 'user' PASSWORD 'password'; CREATE TABLE TEST_TABLE ( INT_VALUE INTEGER, STR_VALUE VARCHAR(50)); COMMIT WORK; ----------------------------------------------------------------- 2. Create very simple PHP script: ----------------------------------------------------------------- <?php $ib = ibase_connect('c:\db\test.gdb','user','password'); $query = ibase_prepare($ib,'insert into TEST_TABLE_2(INT_VALUE, STR_VALUE) values (?, ?)'); $rs = ibase_execute($query,1,null); ibase_close($ib); ?> ----------------------------------------------------------------- After this script will be executed, TEST_TABLE table will contain a row with STR_VALUE='' instead of NULL! However inserting the same data through ibase_query() works properly. -- Edit bug report at: http://bugs.php.net/?id=12765&edit=1 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]