Output CSV file should have BOM in order to be opened by Excel correctly
We can input non-ascii character, such as Japanese character, in Zuora database as UTF-8 through Zuora UI or API. Also, we can download csv file through Zuora UI, such as Data Source Export, Revenue Detail (in Z-Finance Accounting Period), Usage file through notification email, and etc.
On the client laptop (pc), CSV file generally is opened by Excel. But these characters are corrupted (broken) in Excel if the CSV file has non-ascii characters.
CSV file should have BOM (byte-order-mark) so that Excel can recognize the character set of CSV file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.