Specials chars from csv to javascript

Question

I have a .csv file. I grab the file using jQuery.get().

$.get("data.csv", function(data) {
    console.log(data)
}, "text")

Later I want to save the file in an xml.

Now my problem is the datatype of my text.

What I have Å, ë, ö, etc.

What I output �, �, �, �

How can I get the correct format of the text from a .csv file into javascript?

Edit

My meta charset is OK: <meta charset="utf-8">

But notice that I don't display the output of the csv file, I just add some more info and save it in an xml.

When I console.log the output I see these � chars. The same when I save it in the xml. But in my csv file I have the correct char.

Edit 2

I just found this awesome tool. It is in AS3.

When I insert Å ë ö I need the output of escape().

When I use javascript.escape() for Å I get weird chars like %uFFFD instead of %C5 so I guess my script tries to escape � to %uFFFD

Solution

Here the solution for people who have the same problem.

$.ajaxSetup({
    'beforeSend' : function(xhr) {
        xhr.overrideMimeType('text/html; charset=iso-8859-1');
    }
})

$.get("data.csv", function(data) {
    console.log(data)
}, "text")

More importantly, what's the `Content-Type` header that's sent by the server? — Ja͢ck, Mar 11 '13 at 08:24
you need to replace special characters with ISO Latin-1 codes.... — A.T., Mar 11 '13 at 08:28

score 1 · Accepted Answer · edited Jul 07 '19 at 02:00

1

you need to replace special characters with ISO Latin codes. for more reference check this link: http://www.utexas.edu/learn/html/spchar.html

edited Jul 07 '19 at 02:00

cs95

379,657
97
704
746

answered Mar 11 '13 at 08:30

A.T.

24,694
8
47
65

1

Your tip was nice, caused me to find this http://stackoverflow.com/questions/330331/jquery-get-charset-of-reply-when-no-header-is-set – Ron van der Heijden Mar 11 '13 at 09:52

score 0 · Answer 2 · answered Mar 11 '13 at 08:12

0

Try adding the following to the page's header

<meta http-equiv="content-type" content="text/html;charset=utf-8" />

answered Mar 11 '13 at 08:12

Arun P Johny

384,651
66
527
531

I don't display the output, I just want to data. My charset in the file that loads this javascript I have `` – Ron van der Heijden Mar 11 '13 at 08:22

score 0 · Answer 3 · answered Mar 11 '13 at 08:12

Use one of the escape sequences in the string. For instance,The escape sequences in Javascript all begin with the backslash character, . This character lets the application processing the string know that what follows is a sequence of characters that need special handling.

Specials chars from csv to javascript

Edit

Edit 2

Solution

3 Answers3