Japanese characters are appearing garbled in csv output
Hi,
We have a PL/SQL package that creates CSV file using UTL_FILE utility and this file is saved into UTL_Directory. When we try to write Japanese characters into this file, they appear garbled. We have tried using Japanese encoding like "JAPANESE_JAPAN.JA16EUC" and "JAPANESE_JAPAN.JA16SJIS" as well as UTF8 encoding, but still the problem persists. Anyone has any idea as to how to approach this issue?