From d7d5eccd3f042830998bfec3642798eff0e9d7c0 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 1 Oct 2006 16:35:45 +0000 Subject: [ticket:318] has a user receiving back a unicode from a SHOW CREATE TABLE for some reason --- lib/sqlalchemy/databases/mysql.py | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'lib/sqlalchemy/databases/mysql.py') diff --git a/lib/sqlalchemy/databases/mysql.py b/lib/sqlalchemy/databases/mysql.py index f833489d2..0685397d7 100644 --- a/lib/sqlalchemy/databases/mysql.py +++ b/lib/sqlalchemy/databases/mysql.py @@ -377,7 +377,9 @@ class MySQLDialect(ansisql.ANSIDialect): """ c = connection.execute("SHOW CREATE TABLE " + table.name, {}) desc_fetched = c.fetchone()[1] - if type(desc_fetched) is not str: + if type(desc_fetched) is unicode: + desc_fetched = str(desc_fetched) + elif type(desc_fetched) is not str: # may get array.array object here, depending on version (such as mysql 4.1.14 vs. 4.1.11) desc_fetched = desc_fetched.tostring() desc = desc_fetched.strip() -- cgit v1.2.1