32405 error

Greetings, I have created a blobspace and intend to store image files within. The blobspace is set up OK and will accept the BLOB TEXT type of data no problem. However, I want to use dbaccess to LOAD files (such as .jpg). I keep getting an 32405 error which is telling me that :- 32405 : incorrectly formed hexadecimal value. I have tried LOADing all sorts of files but to no avail. After scannning the usual few hundred pages of documentation I see nout of much help at this stage. I figure it may have something to do with GLS locales but not too sure. (btw, using default en_us) (Using Informix On-Line server 7.31 on Solaris 2.7) Any pointers? Cheers, Willie

William Fisher wrote: > > Greetings, > > I have created a blobspace and intend to store image files within. The > blobspace is set up OK and will accept the BLOB TEXT type of data no > problem. > > However, I want to use dbaccess to LOAD files (such as .jpg). I keep > getting an 32405 error which is telling me that :- > > 32405 : incorrectly formed hexadecimal value. > > I have tried LOADing all sorts of files but to no avail. After scannning > the usual few hundred pages of documentation I see nout of much help at this > stage. I figure it may have something to do with GLS locales but not too > sure. (btw, using default en_us) > > (Using Informix On-Line server 7.31 on Solaris 2.7) Download the SQLCMD source code from the IIUG software archive. Extract it. Look at the file unload.format which describes the format for loaded data. Then convert your JPG files to the correct format (painful, but necessary if you use standard Informix load utilities). -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"