lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]


* 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*).