Thanks a lot for your help. I am using sqlite3.
On Wed, Feb 3, 2010 at 9:11 AM, Florian Weimer
<fw@deneb.enyo.de> wrote:
* 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*).
