We need to export a file in csv formatted file from java that contains foreign language characters. We can do this by putting the BOM information on the first line but we also need to have the sep=, on the first line as in Europe their machines default to a semicolon as the separator. (This is a customer facing application and we can't have them change the separator in windows)
It seems that you can't do both at the same time. If we use the BOM it put all the columns in the first column and if we use sep= it separates them out but the language is all garbage.
UTF8_BOM = "\uFEFF";