- attached pg_unicode_testcase.py
Engine.execute() and Engine.text() return string columns as str despite convert_unicode=True
Issue #1120
resolved
When creating an engine with convert_unicode=True, Engine.execute() and Engine.text() return any string columns as str objects, while the equivalent Table.select() returns these columns as unicode objects. Tested this on sqlite and Postgres, the problem only occurs with Postgres.
Comments (2)
-
Account Deleted -
repo owner - changed status to invalid
result types need to be specified for text():
result = engine.execute(text( """ SELECT content FROM test """, typemap={'content':sa.String()}, )).fetchall()
- Log in to comment
Testcase, insert a valid postgres:// url and run