How to insert data into a vargraphic data type field. I have done the following
CREATE TABLE TEST_TABLE (FLD1 VARGRAPHIC(20))
This is done succesfully
INSERT INTO TEST_TABLE VALUES('TEST')
This gives a SQL error
Please let me know how I can acheive it.
You'll need to use the vargraphic() function --
insert into test_table values (vargraphic('TEST', 4));
This should convert your text to something the vargraphic column can accept.
Next time report the error you receive, as it's impossible to read minds.
Last Wiki Answer Submitted: May 4, 2005 11:11 am by Orcledba0 pts.