Cyber Monday Sale! Use DMXCYBER24 promo code for 50% OFF.

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?
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:
Hello,

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