Universal Data Exporter ASP Support Product Page
Answered
export to *.csv - strange characters
Asked 11 May 2012 16:00:44
2
have this question
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. Replies
Replied 15 May 2012 07:22:22
15 May 2012 07:22:22 Teodor Kuduschiev replied:
Hello,
What is the database table encoding you are using?
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:
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?
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:
Hello,
If you see é characters - that means that the character encoding of your database is different than utf-8.
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?
Why not use the same pullddown menu as the SmartMailer extension where you can change the charset?