bom csv java_如何在java中添加UTF-8 BOM

I have a Java stored procedure which fetches record from the table using Resultset object and creates a csv file.

BLOB retBLOB = BLOB.createTemporary(conn, true, BLOB.DURATION_SESSION);

retBLOB.open(BLOB.MODE_READWRITE);

OutputStream bOut = retBLOB.setBinaryStream(0L);

ZipOutputStream zipOut = new ZipOutputStream(bOut);

PrintStream out = new PrintStream(zipOut,false,"UTF-8");

out.write('\ufeff');

out.flush();

zipOut.putNextEntry(new ZipEntry("filename.csv"));

while (rs.next()){

out.print("\"" + rs.getString(i) + "\"");

out.print(",");

}

out.flush();

zipOut.closeEntry();

zipOut.close();

retBLOB.close();

return retBLOB;

But the generated csv file doesn't show the correct german character. Oracle database also has a NLS_CHARACTERSET value of UTF8.

Please suggest.

解决方案

To write a BOM in UTF-8 you need PrintStream.print(), not PrintStream.write().

Also if you want to have BOM in your csv file, I guess you need to print a BOM after putNextEntry().