Excel CSV to MySQL
843859Sep 30 2006 — edited Oct 2 2006I'm writing a code that import Unicode CSV file to MySQL table in Java.
The operator who will work on my program does things like that: Open MS Excel-> write text in any language-> Save file as Unicode CSV-> Open My program-> Import the saved CSV(my program imports CSV file to MySQL table and shows it on JTable)
In english texts, the program is working corrently. That seems Latin1 charset. But when i write in Mongolian (Unicode), unwanted chars are shown in JTable.
I need to know how to solve this. Plz help me.
1. Is the CSV suppord UTF-8
2. Is there any File Input Stream that reads file as UTF-8 in Java; or is there any property that identifies an stream is UTF-8. I don't know Java well. Just a newbie that just migrating from Delphi.
3. I can see that there is no problem to show already inserted unicode text on my JTable. So the problem is on either Saving As CSV or Reading CSV file to Java String