Hi all,

We are currently converting the old 4GL system using VB, connecting to
Informix SE using Informix ODBC.

Everything works fine apart from inserting/updating records that have single
quotes in them

eg insert into table....blahh blahh "This code's all wrong" etc etc

The old Informix system seems to handle single quotes in strings just fine
but the ODBC drivers don't like them.

I can obviously search for the erroneous quote and replace it with something
else and then do the reverse when i read it back, however that would mean
going through all the old Informix code and doing the same thing, something
I don't really want to do!

Anyone got any ideas, its obviously something to do with the ODBC but can't
see anything obvious in the settings etc

Thanks in advance

Mark Jerrom