Return character data as string rather than byte array about pypyodbc

[GoogleCodeExporter]

I actually verified that the feature I am suggesting is there in pyodbc, so it 
makes a lot of sense to fix it. 

Original comment by [email protected] on 8 Jul 2013 at 6:54

[GoogleCodeExporter]

Issue 13 has been merged into this issue.

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

[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, can you try adding "unicode_results=True":
like below:

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


And see if it works?

Original comment by [email protected] on 9 Jul 2013 at 5:21

[GoogleCodeExporter]

I have updated the source code in GitHub:

https://github.com/jiangwen365/pypyodbc/blob/master/pypyodbc.py

Can you try again and see if it works?

Original comment by [email protected] on 9 Jul 2013 at 11:31

• Changed state: Accepted

[GoogleCodeExporter]

fixed in version 1.1.5

Original comment by [email protected] on 11 Jul 2013 at 12:03

• Changed state: Fixed