I'd like to create an import file wizard on android based on csv file.
I use au.com.bytecode.opencsv but I'm in front of a encoding problem.
Excel have multiple save format and one is "Unicode Document", it seemed to be a good idea because we can't manage the encoding for the other excel format.
But when I use the data, I know how to handle UTF8 without BOM but not UTF-16. A simple strvar.equals("name") doesn't work.
I'd like to handle UTF8 without BOM, with BOM, UTF 16 etc.. How can I handle the encoding nightmare ? I think I have to detect the format and then convert it but I need that my code is robust.
Regards