Oninit cdi / Archive
Talk to an expert →

Inserting data into BYTE columns

Posted in 2000

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Migration, Import/Export & Data Conversion

dondpoon@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

I have a BYTE column under my Informix table to store binary data. I can't insert data into it successfully. I read the Informix Guide to SQL: Reference (http://www.informix.com/answers/english/docs/dbdk/infoshelf/sqlr/02.fm6 .html#108930) and it only claim that one can add BYTE data in the following ways: - With the dbload or onload utilities - With the LOAD statement (DB-Access) - From BYTE(loc_t) host variables (INFORMIX-ESQL/C) Are they the only methods? Has anyone ever insert a BYTE data successfully with another approaches? (Using OLEDB?!...) Thanks, -dp Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to dondpoon@my-deja.com
Timothy A. Brown — — source: Informix-list mailing list archive (1991-1998)

When using LOAD and UNLOAD from DBACCESS, remember to use the -X flag when dealing with BLOB data. This formats nonprintable ASCII characters as hexadecimal.

Glossary