Encoding issue in Java

encoding, java, oracle10g

Solution

"ANSI" in "Notepad" means whatever codepage your windows is using. Try ISO8859-1, it work in most case.

Problem

I have a CSV file that contains both ASCII & Unicode characters. say "ÅÔÉA". I am not sure abt the encoding format of this file, but when I open it in Notepad, it shows "ANSI" as its encoding standard. I fetch these contents of CSV in UTF-8 encoded format. fr = new InputStreamReader(new FileInputStream(fileName),"UTF-8"); but when I store it in DB these special characters, except "A", are not stored properly. the characters get scrambled I wish all the characters to be stored properly. Any idea?

Original source