On-Rev: irev to mysql to html charset (apostrophes, etc.) confusion?
pete at mollysrevenge.com
Mon Oct 3 19:02:55 CDT 2011
In SQLite, the way to escape an apostrophe is to precede it with another
apostrophe, not a backslash. mySQL allows either method, not sure about
other SQL implementations.
Molly's Revenge <http://www.mollysrevenge.com>
On Mon, Oct 3, 2011 at 10:40 AM, Pierre Sahores <sc at sahores-conseil.com>wrote:
> Le 3 oct. 2011 à 18:42, Bob Sneidar a écrit :
> > How are you escaping your sql?
> If not, it needed where "it's needed" becomes "it\'s needed" to be stored
> in your SQL backend.
More information about the use-livecode