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

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.

Resolution

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

Cumulative Update 2 for Host Integration Server 2016

Cumulative Update 4 for Host Integration Server 2013

Status

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

References

Learn about the terminology Microsoft uses to describe software updates.