Code: Select all
In places where there are Unicode characters I would use SciTE and Excel to open it and see text like this: æè°¢GPSå¨ä»¶çå•¥ç¨å¸
Which (I thought) was "gobbly-gook" and there was something wrong with my call. My above text is within an XML framework. Excel opens the XML structurally correct but I still see the SAME strange characters listed above.
I then saved the above Excel file as a "text file". To my surprise when I open my newly-saved text file with SciTE, I can see the correct Unicode text "感谢GPS器件的工程师". If I re-open the text file using the import wizard and specifiy 65001-Unicode (UTF-8), the unicode shows up correctly in Excel.
So apparently the "gobbly-gook" text is actually meaningful however why isn't it displaying correctly in SciTe? My original text file has utf-8 encoding. How is excel converting the characters? Any ideas on what it is using and if I can convert it somehow in my WinHTTP call?
As always, thank you for any / all help!