CSV report with "right single quotation mark" displays garbage characters when opening with Excel

Issue:

We have a report title text that contains a "right single quotation mark" character. 

The report can be exported to csv file format and when opening it with a text editor it displays fine. However, when opening with Excel program, the right single

quotation mark is replaced with "’".

What is the cause of this and how can this be resolved ?

Solution:

When opening the CSV file in Excel, the right single quotation mark character is converted into the "’" symbol. This is because Excel opens the CSV file using the default windows encoding (Windows-1252) and hence the character is encoded as per the Windows-1252 characterset.

A comma-separated values (CSV) file is really a delimited text file, but if you want to open the file in Excel then you can re-import the CSV file from within Excel using the "Import data from text file" and choose a UTF encoding.

Alternatively, you can use the apostrophe character (') instead of "right single quotation mark" (’) in the report. 

This is a universal issue with character encodings and is not specific to Jaspersoft.