search

greenew / pypyodbc

Automatically exported from code.google.com/p/pypyodbc
0 stars 0 forks source link

Handle unicode in table column #38

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1.Create a table with pypyodbc, with some column headers containing character Σ
2.Read the column header using cursor.description

What is the expected output? What do you see instead?
The expected string should contain a good string with unicode encoding
The encoding of Σ turns into \xa6\xb2 which is not recognizable by python

What version of the product are you using? On what operating system?
Version:1.3.0 on windows 7 64 bit

Please provide any additional information below.
I don't know if I was doing something wrong, but the description property seems 
doesn't return correct column header string properly if there is unicode 
character contained. I tried to search internet but couldn't find solution

Original issue reported on code.google.com by capan...@gmail.com on 13 Mar 2014 at 2:44

GoogleCodeExporter commented 8 years ago 
Try to set unicode_results=True param in yout pypyodbc.connect call.

Original comment by alex.s.y...@gmail.com on 25 Jun 2014 at 7:49