I start with an excel file with the contents in each row:
TEST çığ öğö çüş
Then I export this file as a CSV file and save it as
ANSI format (which from what I have read is same as
US-ASCII). When I try to open it with excel again, it correctly decodes the characters. If I import this file to a program like
Toad (Oracle DB client) I get garbage as expected. How is it possible that Excel is able to correctly deocode these characters while others cannot ?