FIX: Data providers for DB2 fail to convert binary data to ASCII when table has multiple "binary as character" columns

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Applies To

Host Integration Server 2013 Host Integration Server 2016

Symptoms

Consider the following scenario:

You run a query against a DB2 database that contains multiple columns that are configured as binary data fields.
You configure interpretation of the binary data by setting the property Binary as Character in the connection string.

The result set shows that some of the binary fields are not correctly converted to ASCII, instead showing EBCDIC values.

The fix that resolves this problem is included in the following cumulative updates for Host Integration Server:

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Learn about the terminology Microsoft uses to describe software updates.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.