Re: when I insert table, value is a string contains apostrophe - it throws an error there - how to fix

[noel frankinet <noel.frankinet@...>]

Florian Weimer a écrit :
> * noel frankinet:
>
>   
> > you must double the inside quote quote in sql  : 'MFD''s web managment'
> >     
>
> Ahem.  This really depends a lot on the database and on the connection
> state.  Blindly doubling ' does not work in all cases.
>
> For instance, for PostgreSQL, LuaSQL offers a conn:escape(str) method
> which is implemented by the PostgreSQL folks themselves and thus very
> likely correct (but the older version wasn't for multi-byte encodings
> *sigh*).
>
>   
It's standard sql

Noel