Can't get column value in the row by column name in MS ACCESS 2010 about pypyodbc

[GoogleCodeExporter]

I think by setting to unicode_results to True when connecting will solve the 
problem. 

How do you connect to the mdb file, did you use access connnection string to 
connect, or did you use the win_connect_mdb shortcut method to connect?

if you used connect string, please add "unicode_results=True":
like below:

conn = pypyodbc.connect(u'Driver={Microsoft Access Driver 
(*.mdb)};DBQ=\\YourMDBfilepath.mdb',unicode_results=True)


if you used win_connect_mdb, then you will need to check the source code of 
win_connect_mdb defination in pypyodbc, if there's unicode_results = True in it.

Next version I will default has win_connect_mdb method set unicode_results to 
True to avoid that problem

Original comment by [email protected] on 17 Apr 2013 at 2:02

• Changed state: Accepted

[GoogleCodeExporter]

Original comment by [email protected] on 9 Jul 2013 at 3:12

• Changed state: Duplicate