Bug 870433 - pyodbc unicode handling broken on 64bit systems
pyodbc unicode handling broken on 64bit systems
Product: Fedora
Classification: Fedora
Component: pyodbc (Show other bugs)
x86_64 Linux
unspecified Severity medium
: ---
: ---
Assigned To: Honza Horak
Fedora Extras Quality Assurance
Depends On:
  Show dependency treegraph
Reported: 2012-10-26 09:19 EDT by Martin Wilck
Modified: 2012-12-03 07:59 EST (History)
1 user (show)

See Also:
Fixed In Version: pyodbc-2.1.11-1.fc16
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2012-12-03 07:59:21 EST
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Martin Wilck 2012-10-26 09:19:17 EDT
Description of problem:
pyodbc in Fedora 17/18 is missing important fixes for Unicode handling:


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):

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

How reproducible:

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 09:21:42 EDT
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 11:47:27 EDT
(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 12:14:24 EDT
pyodbc-2.1.11-1.fc18 has been submitted as an update for Fedora 18.
Comment 4 Fedora Update System 2012-10-31 12:17:41 EDT
pyodbc-2.1.11-1.fc17 has been submitted as an update for Fedora 17.
Comment 5 Fedora Update System 2012-10-31 12:18:23 EDT
pyodbc-2.1.11-1.fc16 has been submitted as an update for Fedora 16.
Comment 6 Fedora Update System 2012-10-31 21:22:39 EDT
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:
then log in and leave karma (feedback).

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