Universal Data Exporter ASP Support Product Page
export to *.csv - strange characters
Asked 11 May 2012 16:00:44
11 May 2012 16:00:44 MX Addict posted:
I try to export a recordset to a *.csv file. So far this works fine only some characters shows incorrect like é becomes Ã©. I think it has to do with utf-8.
Replied 15 May 2012 07:22:22
15 May 2012 07:22:22 Teodor Kuduschiev replied:
What is the database table encoding you are using?
Replied 15 May 2012 07:50:53
15 May 2012 07:50:53 MX Addict replied:
I use a 2010 Access database [where in Access can I find the charset?]. I did some research creating a *.asp page which export a *.csv file including the following code:
Response.ContentType = "application/vnd.ms-excel"
Response.charset = "iso-8859-1"
Response.AddHeader "Content-Type", "text/html;charset=iso-8859-1"
Response.AddHeader "content-disposition", "attachment; filename=file.csv"
This works fine with the iso-8859-1 charset. So maybe I need to change UTF-8 to iso-8859-1 in the DmxDataExporter file.
Why can't I change this by the extension itself?
Replied 16 May 2012 07:04:13
16 May 2012 07:04:13 Teodor Kuduschiev replied:
If you see Ã© characters - that means that the character encoding of your database is different than utf-8.
Replied 16 May 2012 07:41:51
16 May 2012 07:41:51 MX Addict replied:
So the only way to change the charset in UDE is editing the DmxDataExporter file and find/replace utf-8 to iso-8859-1.
Why not use the same pullddown menu as the SmartMailer extension where you can change the charset?
Reply to this topic