Bug 870433 - pyodbc unicode handling broken on 64bit systems
Summary: pyodbc unicode handling broken on 64bit systems
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Fedora
Classification: Fedora
Component: pyodbc
Version: 18
Hardware: x86_64
OS: Linux
unspecified
medium
Target Milestone: ---
Assignee: Honza Horak
QA Contact: Fedora Extras Quality Assurance
URL: http://code.google.com/p/pyodbc/issue...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-10-26 13:19 UTC by Martin Wilck
Modified: 2012-12-03 12:59 UTC (History)
1 user (show)

Fixed In Version: pyodbc-2.1.11-1.fc16
Clone Of:
Environment:
Last Closed: 2012-12-03 12:59:21 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

Description Martin Wilck 2012-10-26 13:19:17 UTC
Description of problem:
pyodbc in Fedora 17/18 is missing important fixes for Unicode handling:

http://code.google.com/p/pyodbc/wiki/ReleaseNotes

2.1.8 - 2010-09-06

A major release for Mac OS/X, Unicode, and 64-bit issues, plus a few suggestions. Thanks for the reports and suggestions.

Unicode handling has been completely reworked, fixing a number of issues on platforms where the size of a SQLWCHAR did not match the size of a Python Unicode character. This includes Mac OS/X and most 64-bit Linux distributions.

Version-Release number of selected component (if applicable):
pyodbc-2.1.5-7.fc18.x86_64
freetds-0.91-3.fc17.x86_64
unixODBC-2.3.1-1.fc17.x86_64

See also http://code.google.com/p/pyodbc/issues/detail?id=78&can=1&q=UTF-16

How reproducible:
always

Steps to Reproduce:
1. connect to SQL Server using pyodbc / freetds, TDS Version 7.1
2. fetch some values
  
Actual results:
(u'\U00630045\U006e006f\U006c0065', )

Expected results:
(u'Econel', )

Additional info:
Solved in pyodbc-3.0.6-1.fc19.x86_64 (rawhide). That
s the version I produced the "Expected results" output with. The release notes indicate that an update to 2.1.8 would suffice to fix this issue.

Comment 1 Martin Wilck 2012-10-26 13:21:42 UTC
I notice that pyodbc 3.0.6 has been in rawhide for since August... When will it come to the main distro?

Comment 2 Honza Horak 2012-10-31 15:47:27 UTC
(In reply to comment #1)
> I notice that pyodbc 3.0.6 has been in rawhide for since August... When will
> it come to the main distro?

I'm not planning to do so, but I'm going to update to 2.1.11 in stable releases, because of fixes you described and others.

Comment 3 Fedora Update System 2012-10-31 16:14:24 UTC
pyodbc-2.1.11-1.fc18 has been submitted as an update for Fedora 18.
https://admin.fedoraproject.org/updates/pyodbc-2.1.11-1.fc18

Comment 4 Fedora Update System 2012-10-31 16:17:41 UTC
pyodbc-2.1.11-1.fc17 has been submitted as an update for Fedora 17.
https://admin.fedoraproject.org/updates/pyodbc-2.1.11-1.fc17

Comment 5 Fedora Update System 2012-10-31 16:18:23 UTC
pyodbc-2.1.11-1.fc16 has been submitted as an update for Fedora 16.
https://admin.fedoraproject.org/updates/pyodbc-2.1.11-1.fc16

Comment 6 Fedora Update System 2012-11-01 01:22:39 UTC
Package pyodbc-2.1.11-1.fc16:
* should fix your issue,
* was pushed to the Fedora 16 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing pyodbc-2.1.11-1.fc16'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/FEDORA-2012-17395/pyodbc-2.1.11-1.fc16
then log in and leave karma (feedback).


Note You need to log in before you can comment on or make changes to this bug.