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/

Leave a Reply