On-Rev: irev to mysql to html charset (apostrophes, etc.) confusion?

Pete 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.
Pete
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 mailing list