Re: can INFORMIX insert a '"' (double quote) in a char field?

In article <1993Mar4.213639.22530@netcom.com> bobb@netcom.com (Bob Beaulieu) writes: > >Can anyone ADD data to a char field in an INFORMIX database that contains >quotes? Let's say you have a table (abc) which has 1 field (a) which is >a char type sizeof 15; can you add the below record? note that "this is a 'test'" is 16 chars long... >insert into abc values ("this is a test"); This works >insert into abc values ("this is a 'test'"); This works >insert into abc values ("this is a "test""); This doesn't true >insert into abc values ('this is a "test"'); This doesn't not true: this worked fine for me on SE 4.0 and also SE 5.0. However, it would not be a valid character string literal in ESQL/C; perhaps that is the problem? >insert into abc values ("this is a \\"test\\""); This doesn't true; and this is an inconsistency between 4GL and SQL. In 4GL this works: LET char_var = "this is a \\"test\\"" You can put the above INSERT into a 4GL program and it compiles fine, but when you execute it you get an SQL error -201 (syntax.) Hope this helps a little, Dave Cortesi