This is a migrated thread and some comments may be shown as answers.

Charactors missing in CSV datasources

1 Answer 28 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Janitha
Top achievements
Rank 1
Janitha asked on 19 Apr 2018, 06:19 AM
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?

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 23 Apr 2018, 02:17 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Janitha
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or