Chinese character in the csv file
843842Oct 3 2008 — edited Oct 3 2008Hi all,
I have code below , I am using OpenCSV API to write data to csv.
I am using jdk1.4 and NetBean 6.1 and database is DB2.
The DB2 encoding is UTF-8 , the chinese data is inserted correct to database , but when i tried to retrieve it using
rs.getString("REGISTER_NAME") , it display "???????" , below is the code
FileWrite fileWriter = new FileWriter(PARENT_PATH + WRITE_FILE);
CSVWriter writer = new CSVWriter(fileWriter);
// feed in your array (or convert your data to an array)
while (rsVoucherCode.next()) {
String register_name = rsVoucherCode.getString("REGISTER_NAME");
System.out.println("register_name :" + register_name);
String test = new String(register_name.getBytes("UTF-8"), "Big5");
int register_optin = rsVoucherCode.getInt("REGISTER_OPTIN");
String[] entries = (test+"#"+String.valueOf(register_optin)).split("#");
writer.writeNext(entries);
}
writer.close();
Anyone have any ideas or suggestion is much appreciated . Thanks