Encoding of column names not handled when using cursors directly

[richard-reece]

When using the connection / cursor directly using code like:

with connection.cursor() as cursor:
    cursor.execute("select * from menu_application")
    desc = cursor.description
    nt_result = namedtuple("Result", [col[0] for col in desc])
    r = [nt_result(*row) for row in cursor.fetchall()]

The column names are encoded, resulting in names like 'm\x00a\x00_'.

The solution, as discovered from mkleehammer/pyodbc#194 (comment) is to configure the connection with:

self.connection.setdecoding(pyodbc.SQL_WMETADATA, encoding='utf-32le')