lotus notes - Exporting Chinese characters to CSV file results in it being converted to question marks -
we exporting lotus notes documents csv file. of field have chinese characters in them. visible in lotus notes (though don't understand them) when export them csv file converted question marks. below code snippet using export:
fieldnames = split("field1,field2,field3,field4", ",") set stream = session.createstream if stream.open(csvfilename) call stream.truncate() forall f in fieldnames call stream.writetext("""" + doc.getitemvalue(f)(0) + """,") end forall ..... ..... ..... end if
here if field field1
contains chinese characters , exported, converted question marks. how export chinese characters?
set charset "utf-16" stream: stream.open(csvfilename, "utf-16")
works chinese.
Comments
Post a Comment