Could anyone from group help me how to insert/update the data type
"text" in informix IDS 11.7.
I have tried in many sceneraio and these are some of them .
I tried in DBACCESS /ISQL and php applications it throws the error .
OR let me know how to insert the Query from the PHP applications .

informix@HR-Server:~> onstat -

IBM Informix Dynamic Server Version 11.70.UC2E -- On-Line -- Up
00:00:34 -- 152348 Kbytes


informix@HR-Server:~> onstat -d

IBM Informix Dynamic Server Version 11.70.UC2E -- On-Line -- Up
00:01:05 -- 152348 Kbytes

Dbspaces
address number flags fchunk nchunks pgsize flags
owner name
4ae7c818 1 0x60001 1 1 2048 N BA
informix rootdbs
4c6e21c8 2 0x40001 2 1 2048 N BA
informix datadbs
4c6e2338 3 0x42001 3 1 2048 N TBA
informix temp1dbs
4c6e24a8 4 0x42001 4 1 2048 N TBA
informix temp2dbs
4c6e2618 5 0x42001 5 1 2048 N TBA
informix temp3dbs
4c6e2788 6 0x42001 6 1 2048 N TBA
informix temp4dbs
4c6e28f8 7 0x40001 7 1 2048 N BA
informix logdbs
4c6e2a68 8 0x40001 8 1 2048 N BA
informix phydbs
4c6e2bd8 9 0x60011 9 1 2048 N BBA
informix blob1
9 active, 2047 maximum

Note: For BLOB chunks, the number of free pages shown is out of date.
Run 'onstat -d update' for current stats.

Chunks
address chunk/dbs offset size free bpages
flags pathname
4ae7c988 1 1 0 1250000 712430 PO-
B-- /informix/chunks/rootdbs
4c6e2d48 2 2 0 10240000 9868205 PO-
B-- /informix/chunks/datadbs
4c6e3018 3 3 0 512000 511947 PO-
B-- /informix/chunks/temp1dbs
4c6e3200 4 4 0 512000 511947 PO-
B-- /informix/chunks/temp2dbs
4c6e33e8 5 5 0 512000 511947 PO-
B-- /informix/chunks/temp3dbs
4c6e35d0 6 6 0 512000 511947 PO-
B-- /informix/chunks/temp4dbs
4c6e37b8 7 7 0 10240000 10239947 PO-
B-- /informix/chunks/logdbs
4c6e39a0 8 8 0 1024000 1023947 PO-
B-- /informix/chunks/phydbs
4c6e3b88 9 9 0 1024000 ~1019951 1024000
POBB-- /informix/chunks/blob1
9 active, 32766 maximum

NOTE: The values in the "size" and "free" columns for DBspace chunks
are
displayed in terms of "pgsize" of the DBspace to which they
belong.


Expanded chunk capacity mode: always

CASE -1

create table "informix".emp
(emp_name text);

INSERT INTO emp (emp_name)
VALUES
(CAST('super' AS text));


9634: No cast from char to text.

CASE -2

create table "informix".emp
(emp_name text);

INSERT INTO emp (emp_name)
VALUES
('super');

617: A blob data type must be supplied within this context.

CASE -3

create table "informix".emp1
(emp_name1 BYTE IN blob1);

INSERT INTO emp1 (emp_name1)
VALUES
('super');


617: A blob data type must be supplied within this context.

CASE-4

create table "informix".emp1
(emp_name1 BLOB)
PUT emp_name1 IN (blob1);

INSERT INTO emp1 (emp_name1)
VALUES
(FILETOBLOB('super'));

9821: Space (blob1) is not an sbspace.

But blob1 is an sbspace
informix@HR-Server:~> onstat -d | grep -i blob1
4c6e2bd8 9 0x60011 9 1 2048 N BBA
informix blob1
4c6e3b88 9 9 0 1024000 ~1019951 1024000
POBB-- /informix/chunks/blob1

informix@HR-Server:~> onstat -c | grep -i blob1
SBSPACENAME sbspace,blob1

If i am getting any help from peoples it will be great as it very
urgent.