Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001062

[PHP-DB] Informix & blobs problem -609 / core dump From: Christian Haul (c.haul <email protected>)
Date: 06/19/01

Hi.
 
When trying to insert anything into a BLOB column in informix I get a
-609 error back (invalid use of TEXT/BYTE host variable), no matter
what parameters used when ifx_create_blob'ing. Inserting into TEXT
columns does work OK.
 
When trying to read anything from a TEXT or BLOB column, php dies.
"child pid 4286 exit signal Segmentation fault (11)"
 
Setup
 
SuSE 7.0
Linux 2.2.19-i686 (PIII)
Informix Dynamic Server 2000 Version 9.21.UC3
apache 1.3.17
php-4.0.4pl1
 
or
 
Sun Solaris 7
U60
Informix Dynamic Server 2000 Version 9.20.UC2
php-4.0.4pl1
apache 1.3.11
 
Attached you'll find a) the db definition b) a small script for
inserting data and c) a small script to read the data.
 
As the informix code didn't change in 4.0.5 (no diff on source in
extensions/informix) I haven't tried upgrading.
 
Help appreciated.
 
TIA,
 
        Chris. 

--
create database test_shen in public;

database test_shen;

create table test (
       id serial,
       b1 blob,
       t1 text,
       primary key (id)
);

select * from test;

grant connect to 'infdb1';
grant all on test to 'infdb1';


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>