Re: Entering ' or " with informix.....

Posted in 1998

Surfer — Fri, 19 Jun 1998 09:51:27 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <6mbgds$n89$1@news.xmission.com>, Jonathan Leffler <jleffler@informix.com> writes > >On Thu, 18 Jun 1998 Sujit.Pal@alltel.com wrote: >> Shouldn't this work? "Le\\' Hermatige". > >Not quite. It includes the backslash as a character. > >Both the following should work: > >'Le'' Hermatige' >"Le' Hermatige" > >> Author: pmilitzer@ultracom.com at internet >> Is it possible to put a quote or double quote in a field in informix >> 7.23. ? An example of this would be: Le' Hermatige . Is this a >> problem with informix? Our vendor says it can't be done cause it >> screws up the SQL statements. > >Now, getting all this through an I4GL or ESQL/C compiler can be trickier. We use RDS and found that the delimiter generated by the CONSTRUCT statement changed from a double to a single quote post 4.11. This caused no end of havoc with some of our programs! -- Surfer! http://www.nevis-vieww.demon.co.uk http://www.nevis-vieww.demon.co.uk/flash Hopeful anti-spam: alter double 'w' to single 'w' to view site & send Email.