[DB-SIG] db module wrapper
Ian Bicking
ianb at colorstudy.com
Fri Aug 20 07:10:36 CEST 2004
Randall Smith wrote:
> The only oddity is non-standard escapes like Postgresql's '\'. '\' is
> not a problem to handle, I just have to know when to treat it as an
> escape character and when not to. Do you know of any other databases
> that use '\' as an escape character or any other non-standard escape
> characters in use?
MySQL also uses \', as well as strings like "maybe?", "\'maybe?\'", or
"\"maybe?\"". SQLite and Firebird -- other databases I am familiar with
-- don't use backslash quoting.
Also note 'maybe\\' and 'maybe\\\'?' (and so on). Backslash quoting can
be a pain.
--
Ian Bicking / ianb at colorstudy.com / http://blog.ianbicking.org
More information about the DB-SIG
mailing list