Charactors missing in CSV datasources

2 posts, 0 answers
  1. Janitha
    Janitha avatar
    14 posts
    Member since:
    Mar 2018

    Posted 19 Apr 2018 Link to this post

    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?
  2. Todor
    Admin
    Todor avatar
    384 posts

    Posted 23 Apr 2018 Link to this post

    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
Back to Top