0 pts.
 Inserting data into a vargraphic data type field
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.

Software/Hardware used:
ASKED: April 28, 2005  9:44 AM
UPDATED: May 4, 2005  11:11 AM

Answer Wiki:
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. David Fitzjarrell
Last Wiki Answer Submitted:  May 4, 2005  11:11 am  by  Orcledba   0 pts.
All Answer Wiki Contributors:  Orcledba   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _