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:
It's impossible.
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.
Update
Following the rumour, pyodbc might be a solution:
http://hamakor.org.il/pipermail/python-il/2007-December/000012.html
http://pyodbc.sourceforge.net/
Categories: