on 08-17-2010 10:20 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.