Re: Inserting records using Informix ODBC

Posted in 2004

Kanchana Padmanabhan — Thu, 4 Mar 2004 11:40:00 -0600 — source: Usenet: comp.databases.informix

--0__=09BBE4DEDFF3B4968f9e8a93df938690918c09BBE4DEDFF3B496 Content-type: multipart/alternative; Boundary="1__=09BBE4DEDFF3B4968f9e8a93df938690918c09BBE4DEDFF3B496" --1__=09BBE4DEDFF3B4968f9e8a93df938690918c09BBE4DEDFF3B496 Content-type: text/plain; charset=US-ASCII Can you provide more specifics about the query you are executing, the error that you are getting back? Also let me know the ODBC or CSDK version you are using? I executed the following & didn't see any problems drop table charTest; create table charTest (charCol CHAR(30)); insert into charTest values('This code''s all wrong'); insert into charTest values("This code's all wrong"); Are you by any chance trying a literal insert into TEXT column? I personally doubt that as you said you are migrating 4GL system to VB. And afaik, 4GL doesn't have support for literal inserts into TEXT columns. Just trying to narrow down the problem area. Regards, Kanchana Padmanabhan Software Engineer R&D - IBM Data Management Group 11200 Lakeview, Lenexa, KS 66219 Tel: 913 599 8674 t/l : 337 8674 Fax: 913 599 7260 |---------+----------------------------> | | "me" | | | <mark@cuskit.co.u| | | k> | | | Sent by: | | | owner-informix-li| | | st@iiug.org | | | | | | | | | 03/04/2004 05:19 | | | AM | | | Please respond to| | | "me" | |---------+----------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: informix-list@iiug.org | | cc: | | Subject: Inserting records using Informix ODBC | >------------------------------------------------------------------------------------------------------------------------------| 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 --1__=09BBE4DEDFF3B4968f9e8a93df938690918c09BBE4DEDFF3B496 Content-type: text/html; charset=US-ASCII Content-Disposition: inline <html><body> Can you provide more specifics about the query you are executing, the error that you are getting back? Also let me know the ODBC or CSDK version you are using? I executed the following & didn't see any problems drop table charTest; create table charTest (charCol CHAR(30)); insert into charTest values('This code''s all wrong'); insert into charTest values("This code's all wrong");  Are you by any chance trying a literal insert into TEXT column? I personally doubt that as you said you are migrating 4GL system to VB. And afaik, 4GL doesn't have support for literal inserts into TEXT columns. Just trying to narrow down the problem area. Regards, Kanchana Padmanabhan Software Engineer R&D - IBM Data Management Group 11200 Lakeview, Lenexa, KS 66219 Tel: 913 599 8674 t/l : 337 8674 Fax: 913 599 7260 <img src="cid:10__=09BBE4DEDFF3B4968f9e8a93df938@us.ibm.com" width="16" height="16" alt="Inactive hide details for "me" <mark@cuskit.co.uk>">"me" <mark@cuskit.co.uk> <table V5DOTBL=true width="100%" border="0" cellspacing="0" cellpadding="0"> <tr valign="top"><td width="1%"><img src="cid:20__=09BBE4DEDFF3B4968f9e8a93df938@us.ibm.com" border="0" height="1" width="72" alt=""> </td><td style="background-image:url(cid:30__=09BBE4DEDFF3B4968f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " width="1%"><img src="cid:20__=09BBE4DEDFF3B4968f9e8a93df938@us.ibm.com" border="0" height="1" width="225" alt=""> <ul> <ul> <ul> <ul>"me" <mark@cuskit.co.uk> Sent by: owner-informix-list@iiug.org 03/04/2004 05:19 AM Please respond to "me"</ul> </ul> </ul> </ul> </td><td width="100%"><img src="cid:20__=09BBE4DEDFF3B4968f9e8a93df938@us.ibm.com" border="0" height="1" width="1" alt=""> To: informix-list@iiug.org cc: Subject: Inserting records using Informix ODBC</td></tr> </table> <tt>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 </tt> </body></html> --1__=09BBE4DEDFF3B4968f9e8a93df938690918c09BBE4DEDFF3B496-- --0__=09BBE4DEDFF3B4968