I recently ran into an issue in pypyodbc 1.3.3 where column names would be truncated to the first character in the name.

I like pypyodbc because it is faster than normal pyodbc and it allows for use in almost any python or pypy version.

The fix is to edit the python file and setting a variable to a strict False:

$ sudo nano /usr/local/lib/python3.4/dist-packages/pypyodbc.py

In pypyodbc.py, in _UpdateDesc() method, line 1735, I see:

force_unicode = self.connection.unicode_results

Based on this flag, few lines below, it will call ODBC_APY accordingly. So I replaced that line above by:

force_unicode = False

and it fixed the problem.

Thanks Leon, the Professional 😎