1921078 - Crystal Reports with Sybase Open Client does not support Unicode

SAP Knowledge Base Article - Public

1921078 - Crystal Reports with Sybase Open Client does not support Unicode

Symptom

  • When a crystal report is created based on a Sybase open Client, the Unicode Characters are displayed incorrectly

          For Example : Arabic Characters are displayed as ???

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • Sybase ASE 15
  • Sybase Open Client 15.0

Reproducing the Issue

  1. Launch Crystal Reports
  2. Go to File >> New >> Blank Report
  3. In Database Expert window, Create a new connection for Sybase Server.
  4. Select the table from the database
  5. Place the field from the table in the Details Section
  6. Execute the report
  7. Unicode Characters are displayed incorrectly.
  8. For example : Arabic characters are displayed as ???

Cause

Crystal Reports with Sybase Open Client ( Sybase Native Client ) does not support Unicode.

Resolution

  • Create a report using an ODBC connection to the Sybase Database.
  • Unicode Characters are displayed correctly (In this case, Arabic Characters)

Keywords

Arabic characters, ???, Sybase open client, Sybase ASE, Sybase Native client. , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013