- Oracle and others properly encode SQL used for defaults

like sequences, etc., even if no unicode idents are used
since identifier preparer may return a cached unicode
identifier.

1 files changed, 2 insertions, 0 deletions

diff --git a/lib/sqlalchemy/engine/base.py b/lib/sqlalchemy/engine/base.py
index 769217454..61755013b 100644
--- a/lib/sqlalchemy/engine/base.py
+++ b/lib/sqlalchemy/engine/base.py
@@ -1814,6 +1814,8 @@ class DefaultRunner(schema.SchemaVisitor):
         """execute a string statement, using the raw cursor,
         and return a scalar result."""
         conn = self.context._connection
+        if not self.dialect.supports_unicode_statements:
+            stmt = stmt.encode(self.dialect.encoding)
         conn._cursor_execute(self.context.cursor, stmt, params)
         return self.context.cursor.fetchone()[0]