Subject OT: SQL Question
Author Rob Schuff

the following e-mail came in to me from a colleague. Does anyone have an
answer for this?

The SQL standard specifies that single quotes are to be used around string
literals (<fieldname>='<value>') in SQL statements. Some implementations
of SQL allow double-quotes, but many require single-quotes.

Does anyone know of a way to handle saving (with SQL UPDATE or INSERT) of
strings that contain internal apostrophes (single quotes), preserving the
single quotes within the string?



Robert Schuff Bull Run Software
rob@... Portland, OR USA