Charactors missing in CSV datasources

[Janitha]

I have created a telerik report which uses Norwegian characters in the report as well as in the csv data sources. But in the Report designer when I go to the preview tab I can see that some special characters that are from the csv data source are missing. Characters in question is 'ØÆÅ'. All the special characters in the report (hard coded) are shown correctly, only the characters from the csv file that is not shown. Hence I went through the Configure CSV data Source and I found out that when parsing the CSV , there also these characters are missing (Shown in the attachment). How can this be fixed or does special characters are not supported for CSV files?

[Todor]

Hi Janitha,

This post seems to duplicate the support ticket 1163073 you opened on the same issue.
I will post the answer that helped solving the issue also here so that the rest of the community could benefit from it:

The problem is probably related to the encoding of the CSV file used to provide the data.
We use the StreamReader Constructor (Stream) when reading the CSV data files. Note that this constructor initializes the encoding to UTF8Encoding.
If the encoding of the CSV file is different, this might result in some symbols not been properly recognized.

My suggestion is to check the CSV file encoding and convert it to UTF8.

Regards,
Todor
Progress Telerik