Re: Entering ' or " with informix.....
Art S. Kagel schrieb:
[snip]
> For example, picture a comment column containing:
>
> <Mister O'Brien said, "I did not say that that's what happened!">
>
> Now for this string there is no way in DBACCESS to enter the string
> because neither single nor double quotes can be used to surround the
> string because it contains both quotation characters.
Ooohps, try this one:
insert into t values ("Mister O'Brien said, "" did not say that that's what happened!""");
My dbaccess answers:
1 row(s) inserted.
What does Your's say? :-)
o.k.; I did not enter t h i s string, but afterwards you can select it!
hth
martin