python, win32, odbc, unicode, ascii, I hate it
I need to get utf-8 (unicode) data instead of 8-bit from a Microsoft Access database (ODBC connection). It seems I've finally found the answer:
From the odbc module of Python Win32 Extensions source code:
SQLBindParameter(..., SQL_C_CHAR, ...)
If I understand the MSDN documentation right (Unicode Drivers), this forces 8-bit instead of any unicode.
Should I find another ODBC driver (if any) or fix this (thanks open source, it's possible)? Time will show.
Following the rumour, pyodbc might be a solution: