sqlobject-cvs

[SQL-CVS] r538 - trunk/SQLObject/sqlobject

[<sub...@co...>]

Author: phd
Date: 2005-01-13 10:43:56 +0000 (Thu, 13 Jan 2005)
New Revision: 538

Modified:
   trunk/SQLObject/sqlobject/converters.py
Log:
Fixed a bug in sqlStringReplace - MySQL and PostgreSQL use backslash to escape quotes.


Modified: trunk/SQLObject/sqlobject/converters.py
===================================================================
--- trunk/SQLObject/sqlobject/converters.py	2005-01-12 17:39:30 UTC (rev 537)
+++ trunk/SQLObject/sqlobject/converters.py	2005-01-13 10:43:56 UTC (rev 538)
@@ -47,7 +47,7 @@
 
 sqlStringReplace = [
     ('\\', '\\\\'),
-    ("'", "''"),
+    ("'", "\\'"),
     ('\000', '\\0'),
     ('\b', '\\b'),
     ('\n', '\\n'),

Re: [SQL-CVS] r538 - trunk/SQLObject/sqlobject

[Ian B. <ia...@co...>]

sub...@co... wrote:
> Author: phd
> Date: 2005-01-13 10:43:56 +0000 (Thu, 13 Jan 2005)
> New Revision: 538
> 
> Modified:
>    trunk/SQLObject/sqlobject/converters.py
> Log:
> Fixed a bug in sqlStringReplace - MySQL and PostgreSQL use backslash to escape quotes.

Did you actually encounter this as a bug?  They should both accept '' as 
well as \'; they are still different than other databases, because you 
have to quote \'s themselves, but you don't have to use that form.

-- 
Ian Bicking  /  ia...@co...  /  http://blog.ianbicking.org