SAP Knowledge Base Article - Public

2005553 - Crystal Reports does not display Oracle Unicode data correctly

Symptom

  • Report containing Oracle CLOB fields displays English characters correctly.
  • Arabic characters are displayed as upside down question marks:

 

Untitled.png

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • Oracle 11g

Cause

  • The CLOB datatype stores single-byte and multibyte character data only.

Resolution

Keywords

CR lob datatype , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 2013