Crystal Report 9 - Can't Display UTF-8 Data

[Former Member]

Dear Sir,

I am using PHP with Crystal Report 9.2 and has problem displaying UTF-8 data from MSSQL field. It shows weird characters instead. I am very sure the data stored in database is in UTF-8 because when I ouput it into the web browser with encoding as UTF-8, it shows correctly. Currently is using ADODB recordset to pass data into CR. I tried using ODBC to connect directly to database and preview the data - same issue.

Now I wonder whether are there any settings need to be done in CR in order to display unicode correctly? From what I read, CR 9 and above should be able to support unicode.

Thanks

AL

[former_member183750 · Accepted solution]

What CR SDK are you using?

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]

[Former Member · Accepted solution]

Sorry to ask, how do we check the CR SDK that is currently using?

Let me provide you with some other details;

Version : 9.2.0.448

Product Type : Full

CR Advanced

Thank you.

[former_member183750 · Accepted solution]

how do we check the CR SDK that is currently using

What CR files are you referencing in your app?

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]

[Former Member · Accepted solution]

If I understand you correctly, my app is using COM object "CrystalRuntime.Application" to generate the report. The report is using TTX file definition and will read the ADO recordset - then export out a PDF file by using the "ExportOptions" method and display the PDF file on a new window browser.

Thank you.

[former_member183750 · Accepted solution]

To be honest, I have no idea if TTX files supported UTF-8... I kinda doubt it. I'd check, but the only person I knwo of that may have a clue is not in until September 28...

Re. ODBC, see if adding the following option to your DSN entry in the odbc.ini file will help:

stmt = SET CHARACTER SET utf8

Also, if I remember right, MS SQL does not install UTF-8 support by default (at least at one time or another it did not...(?).

Oh - one more thing. I've attached a non CR app that I'd like you to use to see what the data it returns looks like. Please give that a try.

- Ludek

Edited by: Ludek Uher on Sep 7, 2011 10:43 AM

[Former Member · Accepted solution]

Thanks for your effort in helping this. I tried to download the attached file but it always downloaded with 0 btyes. I wonder if its corrupted. Can you kindly upload the file again.

Thank you.

[former_member183750 · Accepted solution]

I'll email it directly to you.

- Ludek

[Former Member · Accepted solution]

I have tried connecting to my database. Manage to connect - and attempt to select the fields in a table containing UTF-8 value. The result returned were symbols and weird charaters. Is that you want me to test? Or please let me know if you need me to further test.

Thank you.

[former_member183750 · Accepted solution]

Yup. It don't work in a non CR app built in Delphi, it don't work in CR - where does it work? Are you able to take the ADO recordset and display the data in a data grid or a something like that?

- Ludek