how to read utf-8 chars in opencsv

Question

I am trying to read from csv file. The file contains UTF-8 characters. So based on Parse CSV file containing a Unicode character using OpenCSV and How read Japanese fields from CSV file into java beans? I just wrote

CSVReader reader = new CSVReader(new InputStreamReader(new FileInputStream("data.csv"), "UTF-8"), ';');

But it does not work. The >>Sí, es nuevo<< text is visible correctly in Notepad, Excel and various other text editing tools, but when I parse the file via opencsv I'm getting >>S�, es nuevo<< ( The í is a special character if you were wondering ;)

What am I doing wrong?

Are you sure those other editors interpret the file in UTF-8? — aioobe, Jul 23 '12 at 12:06

score 2 · Answer 1 · answered Dec 05 '16 at 13:09

2

you can use encoder=UTF-16LE,I'm write a file for Japanese

answered Dec 05 '16 at 13:09

Gavin Sheng

21
2

score 1 · Accepted Answer · answered Jul 23 '12 at 12:18

1

Thanks aioobe. It turned out the file was not really UTF-8 despite most Win programs showing it as such. Notepad++ was the only one that did not show the file as UTF-8 encoded and after converting the data file the code works.

answered Jul 23 '12 at 12:18

tom

1,223
6
16
26

score 0 · Answer 3 · answered Jul 23 '12 at 12:12

0

Use the below code for your issue it might helpful to you...

String value = URLEncoder.encode(msg[no], "UTF-8");

thanks, Yash

answered Jul 23 '12 at 12:12

Yash

1,751
13
14

score 0 · Answer 4 · answered May 28 '14 at 13:13

0

Use ISO-8859-1 or ISO-8859-14 or ISO-8859-15 or ISO-8859-10 or ISO-8859-13 or ISO-8859-2 instead of using UTF-8

answered May 28 '14 at 13:13

gurtell

1
1
1

how to read utf-8 chars in opencsv

4 Answers4

Linked