cancel
Showing results for 
Search instead for 
Did you mean: 

Language specific characters changes when export as csv

sampathraj_ch
Member
0 Kudos

I am using the Save as CSV file property of the grid to show the data in excel. But in CSV some spanish characters like í is getting changed to Ã.

Page is having .irpt extension.

I tried .html as well but it is giving the same error.

Could anyone help me in resolving it.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

This is most probably a character set issue. The problem here is that a CSV file, unlike XML, does not contain a declaration of the character set, so there is uncertainty here.

It is possible that the program you are using to open/import the CSV file is using the wrong character set. There is a tool called the chardet library that may help you determine what the encoding is. See http://stackoverflow.com/questions/508558/what-charset-does-microsoft-excel-use-when-saving-files for these and other details.

Otherwise, if your CSV comes from a query against a database, the database collation may not be aligned with the character data you are storing.

Marc