CODEWITHSUNDEEP
sqlinformix
Oleg
Oleg

Reputation: 1775

How can I INSERT data in TEXT datatype field? (Informix)

 CREATE TABLE updater
 (
    nzp_up SERIAL PRIMARY KEY,
    version VARCHAR(50),
    status INT,
    report TEXT
 );

INSERT INTO updater (version, status,report) values ('TestVersion' , 0,"123123123");

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

Upvotes: 6

Views: 14042

Answers (3)

Michał Niklas
Michał Niklas

Reputation: 54342

See my question: Consistent method of inserting TEXT column to Informix database using JDBC and ODBC

It seems that some tools like ODBC drivers can insert text as TEXT while others like JDBC drivers must use PreparedStatent or other techniques.

Upvotes: 1

CheeseConQueso
CheeseConQueso

Reputation: 6051

Using a | (pipe) delimited file, you can use the LOAD command to insert values into blob & text data types. I had the same problem in the past - go to link in my comment

Upvotes: 2

Suj
Suj

Reputation: 31

INSERT INTO updater (version, status,report) 
values ('TestVersion' , 0,"123123123");

and

INSERT INTO updater (version, status,report) 
values ('TestVersion' , 0,'123123123');

have the same effect in mySql.So lets try without double quotes in SQL.

Upvotes: 0

Related Questions