Engine.execute() and Engine.text() return string columns as str despite convert_unicode=True

[Former user]

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.

[Former user]

Testcase, insert a valid postgres:// url and run

[Mike Bayer]

result types need to be specified for text():

result = engine.execute(text(
            """
            SELECT content FROM test
            """,
            typemap={'content':sa.String()},
    )).fetchall()