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

pmilitzer@ultracom.com wrote: > > Hi there, > > 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. It certainly CAN be done. You just have to be careful to use the other quote character to quote the string and even this is not a real problem using 4GL or ESQL/C. On the other hand it can certainly cause you much grief. 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. Again not a problem in 4GL or ESQL/C or even for dbload or the dbaccess load verb. Hmm. Looks like your vendor is just lazy to me! Art S. Kagel