Symptom
- Report containing Oracle CLOB fields displays English characters correctly.
- Arabic characters are displayed as upside down question marks:
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
- Use the NCLOB datatype which stores Unicode data.
- See: Oracle® Database SQL Reference 10g Release 2 (10.2) - Datatypes
Keywords
CR lob datatype , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 2013