1219704 - DB2 Unicode driver incorrectly displays DBCS characters that are stored in DB2

SAP Knowledge Base Article - Public

1219704 - DB2 Unicode driver incorrectly displays DBCS characters that are stored in DB2

Symptom

The Crystal Reports DB2 Unicode driver, crdb_db2cli.dll, incorrectly displays double-byte character set (DBCS) characters stored in a DB2 database that have been created with codepage 819 (iso8859-p1).

Cause

This issue has been assigned ID ADAPT00498770.

Resolution

Hot Fixes or Service Packs address this issue as indicated below. After applying the update, complete these steps:

1.  To enable reporting off non-Unicode DB2 database (that is, DB2codepage=819) change the value of the following registry entry to 'Yes':

Subkey for XI Release 1: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.0\Crystal Reports\Database\DB2\UseOSLocaleForConversion

Subkey for XI Release 2: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.5\Crystal Reports\Database\DB2\UseOSLocaleForConversion

2.  Ensure that the DB2 client environment variable, DB2CODEPAGE, matches the DB2 database codepage. For example, database codepage iso8859-p1: DB2SET DB2CODEPAGE=819.

3.  Set the 'Regional Options' for the Windows account on which the Crystal Reports Designer or Crystal Page/Report Job/Report Application Server processes are running to match the language locale of the DB2 database. For example, for Simplified Chinese DBCS data, set the Control Panel > Regional Settings and Options > Regional Options to 'Chinese (PRC)'.

 

Registry Entry Information

Subkey for XI Release 1: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.0\Crystal Reports\Database\DB2\UseOSLocaleForConversion

Subkey for XI Release 2: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.5\Crystal Reports\Database\DB2\UseOSLocaleForConversion

Type: STRING

Recognized Values: Yes, No

Default Value: No

Creation Method: Hot Fix Installation

Known limitations:

  • DB2 DBCS table and field names are not supported.
  • If the Crystal DB2 driver is enabled to report off non-Unicode data, the same Crystal Reports Designer and Page Server, Job Server, and Report Application Server processes will not report off DB2 Unicode data.

To limit the hot fix behavior to a specific user process, complete these steps:

1.  Delete the above 'UseOSLocaleForConversion' registry entry.

2.  Create a corresponding registry entry with the value "Yes", under the specific Windows user account:

Subkey for XI Release 1: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.0\Crystal Reports\Database\DB2\UseOSLocaleForConversion

Subkey for XI Release 2: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.5\Crystal Reports\Database\DB2\UseOSLocaleForConversion

3.  Configure Page Server, Report Job Server, and Report Application Server processes or the Crystal Reports Designer to run under the specific Windows account.

Unless indicated otherwise, Critical Hot Fix updates from the FTP site have only been tested with English versions of our products.

====================

CAUTION:

Hot Fixes and Service Packs are not designed for OEM versions. Do not apply these updates if you are using an OEM version. To determine if you are using an OEM version, refer to the OEM Product Warning.

====================

BusinessObjects Enterprise and Crystal Reports XI Release 2

For BusinessObjects Enterprise and Crystal Reports XI Release 2, download the most recent Critical Hot Fix (CHF) from the Downloads area of our web site.

BusinessObjects Enterprise and Crystal Reports XI Release 1

For BusinessObjects Enterprise and Crystal Reports XI Release 1, the latest update for this issue is available on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • crdb_db2cli.dll, version 11.0.0.2007, dated 1/30/2006 (commonXIwin_chf.zip)
  • crdb_db2cli_res_chs.dll, version 11.0.0.2007, dated 1/30/2006 (commonXIwin_chf.zip)
  • crdb_db2cli_res_cht.dll, version 11.0.0.2007, dated 1/30/2006 (commonXIwin_chf.zip)
  • crdb_db2cli_res_de.dll, version 11.0.0.2007, dated 1/30/2006 (commonXIwin_chf.zip)
  • crdb_db2cli_res_en.dll, version 11.0.0.2007, dated 1/30/2006 (commonXIwin_chf.zip)
  • crdb_db2cli_res_es.dll, version 11.0.0.2007, dated 1/30/2006 (commonXIwin_chf.zip)
  • crdb_db2cli_res_fr.dll, version 11.0.0.2007, dated 1/30/2006 (commonXIwin_chf.zip)
  • crdb_db2cli_res_it.dll, version 11.0.0.2007, dated 1/30/2006 (commonXIwin_chf.zip)
  • crdb_db2cli_res_jp.dll, version 11.0.0.2007, dated 1/30/2006 (commonXIwin_chf.zip)
  • crdb_db2cli_res_ko.dll, version 11.0.0.2007, dated 1/30/2006 (commonXIwin_chf.zip)
  • crdb_db2cli_res_nl.dll, version 11.0.0.2007, dated 1/30/2006 (commonXIwin_chf.zip)

 

Monthly Hot Fixes and Service Packs

To determine if this issue is also addressed in a Monthly Hot Fix or Service Pack for your product, search the readme file for the Track ID number (that is, ADAPTXXXXXXXX) in the latest Monthly Hot Fix or Service Pack.

Monthly Hot Fixes readmes and Service Pack readmes are available in the Downloads area of our web site.

====================

NOTE:

Issues addressed on one operating system platform at the Weekly Hot Fix level may be addressed later on multiple operating system platforms (if applicable) at the Monthly Hot Fix and Service Packs level. For example, an issue only resolved on the Windows platform in a Weekly Hot Fix may be resolved later on UNIX platforms such as IBM AIX and Sun Solaris in future Monthly Hot Fixes or Service Packs for these platforms.

To determine if these issues are resolved in a Monthly Hot Fix or Service Pack on another platform, search for the Track ID number in the readme at the locations indicated above.

See Also

For more information on the issues addressed in the Hot Fix or Service Pack, view the readme PDF or text file included in the ZIP or TAR file.

For more information on the different update types, refer to our Hot Fix and Service Pack FAQ.

Keywords

CHF 498770 DOUBLE BTYE CHINESE JAPANESE KOREAN TRADITIONAL SIMPLIFIED DB/2 Crystal Reports DB2 Unicode Driver Double-byte Characters , c2018726 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2