I am creating a CSV file with UTF-8 encoding.
It displays the Chinese characters properly if I open it using Notepad++.
It displays the Chinese characters properly if I open it using Notepad.
But, if I open it using Excel, I see garbage values.
If I open it using Notepad and press Control+S and close the file and reopen in Excel, it shows the characters perfectly.
Any clues whats going here?
I also tried to create a normal CSV file which has Encoding GB2312. I then used Unix command iconv to convert the file from "GB2312" to "UTF-8"
This command removes all the Chinese characters and shows only English characters. So, this is not a solution.
It doesn't show Garbage value, but shows ANSI encoding. Why does it picks ANSI encoding by default. And why after opening the same file in Notepad/Notepad++ it opens up with UTF-8.
Also, why just Control+s makes it open in Excel correctly.