Symptoms

Consider the following scenario:

  • You use the Microsoft OLE DB Provider for DB2 that is included with Microsoft Host Integration Server 2010 to query an IBM DB2 table.

  • The IBM DB2 table contains columns that use the IBM DB2 GRAPHIC data type.


In this scenario, the query results that are returned from the IBM DB2 GRAPHIC data type columns are displayed as Chinese characters.

Cause

This problem occurs because the Host Integration Server 2010 OLE DB Provider for DB2 does not correctly handle data conversions from UTF-16 big endian to UTF-16 little endian.

Resolution

Cumulative update information

The fix that resolves this problem is included in cumulative update package 7 for Host Integration Server 2010. For more information about how to obtain the cumulative update package, see Cumulative update package 7 for Host Integration Server 2010.

Status

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

More Information

For information about a similar issue, see FIX: Linked server query results are displayed as Chinese characters from an IBM DB2 table in a Host Integration Server 2010 environment.

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×