thanks for the responses. my application is in C++ actually. I found the following link as a good reference. check it out.

thanks for reply.

I'm importing data from Informix where text format is well saved in a blob column. the newline in the Informix export file is clear. but after imported into SQL, mapped to...