[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