Minor fix for escaping unicode strings in SQLite escaper

stamparm · stamparm · commit 0d2138a4a07f · 2013-02-25T14:06:46.000+01:00
diff --git a/plugins/dbms/sqlite/syntax.py b/plugins/dbms/sqlite/syntax.py
@@ -8,6 +8,7 @@
 import binascii
 
 from lib.core.common import isDBMSVersionAtLeast
+from lib.core.settings import UNICODE_ENCODING
 from plugins.generic.syntax import Syntax as GenericSyntax
 
 class Syntax(GenericSyntax):
@@ -17,7 +18,7 @@ def __init__(self):
     @staticmethod
     def escape(expression, quote=True):
         def escaper(value):
-            return "CAST(X'%s' AS TEXT)" % binascii.hexlify(value)
+            return "CAST(X'%s' AS TEXT)" % binascii.hexlify(value.encode(UNICODE_ENCODING) if isinstance(value, unicode) else value)
 
         retVal = expression
 
