X-Git-Url: https://git.phdru.name/?p=sqlconvert.git;a=blobdiff_plain;f=sqlconvert%2Fprocess_mysql.py;h=d72479e7111bfc0db29b12c7f6bdb1d8aa0561ed;hp=f91f516d2d9236f53dd320f5eb2a958545d54c9d;hb=b83ec9eaf7e388f4061c5e13dd930fd108e4bd77;hpb=bc473dfbbebeea2e2f4e0f368408632e047949ac

diff --git a/sqlconvert/process_mysql.py b/sqlconvert/process_mysql.py
index f91f516..d72479e 100644
--- a/sqlconvert/process_mysql.py
+++ b/sqlconvert/process_mysql.py
@@ -49,6 +49,21 @@ def requote_names(token_list):
                 token.normalized = token.value = '"%s"' % value
 
 
+def unescape_strings(token_list):
+    """Unescape strings"""
+    for token in token_list.flatten():
+        if token.ttype is T.String.Single:
+            value = token.value
+            for orig, repl in (
+                ('\\"', '"'),
+                ("\\'", "''"),
+                ('\\\032', '\032'),
+            ):
+                value = value.replace(orig, repl)
+            token.normalized = token.value = value
+
+
 def process_statement(statement):
     remove_directive_tokens(statement)
     requote_names(statement)
+    unescape_strings(statement)