INSERT Binary Data

Hi, I would like to INSERT Byte-Data INTO a BYTE-Coolumn using SQL This is how it works for SQL-Server: INSERT INTO tblSlime ( ID, Name, Slime ) VALUES (2, 'Fritz', 0x234323432343234323fc4350fc4350fc4350fc4350fc); Is something like this possible for INFORMIX Thx, Peter

Martin Steinwender wrote: > Hi, > > I would like to INSERT Byte-Data INTO a BYTE-Coolumn using SQL > > This is how it works for SQL-Server: > > INSERT INTO tblSlime ( ID, Name, Slime ) > VALUES (2, 'Fritz', 0x234323432343234323fc4350fc4350fc4350fc4350fc);> > Is something like this possible for INFORMIX From the IBM Informix Guide to SQL: Reference (Version 9.4, Part No. CT1SPNA): You can insert data into BYTE columns in the following ways:

June C. Hunt wrote: > Martin Steinwender wrote: > >> Hi, >> >> I would like to INSERT Byte-Data INTO a BYTE-Coolumn using SQL >> >> This is how it works for SQL-Server: >> >> INSERT INTO tblSlime ( ID, Name, Slime ) >> VALUES (2, 'Fritz', 0x234323432343234323fc4350fc4350fc4350fc4350fc);>> >> Is something like this possible for INFORMIX > Seem to be having problems sending mail this morning. The full response should be... From the IBM Informix Guide to SQL: Reference (Version 9.4, Part No. CT1SPNA): You can insert data into BYTE columns in the following ways: - With the dbload or onload utilities - With the LOAD statement (DB-Access) - From BYTE host variables (IBM Informix ESQL/C) You cannot use a quoted text string, number, or any other actual value to insert or update BYTE columns. If you don't already have it, you can find Informix documentation online at http://www.ibm.com/software/data/informix/library -- June Hunt