Inserting NULL values into a column of type TEXT?
Posted in 1996
Jason Bodnar — — source: Informix-list mailing list archive (1991-1998)
I'm trying to insert a NULL value into a column of type TEXT but am
getting the following error:
617: A blob data type must be supplied within this context.
Error in line 1Near character position 528
Here's the INSERT statement (trimmed for brevity):
INSERT INTO current (title, review, photos, ...) VALUES ('Twister',\\'may96/twister/twister.htm', NULL, ...);
I also tried:
INSERT INTO current (title, review, photos, ...) VALUES ('Twister',\\'may96/twister/twister.htm', '', ...);
Obviously, I can insert text into a column of type TEXT (the
preceeding colum 'review' is of type text), but how can I insert a
NULL value or an empty string?
Thanks,
--
Jason C. Bodnar
jasonb@onr.com
Internet Programmer
Cox Interactive Media