How does excel manage to correctly decode this file contents?

Posted on

QUESTION :

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 ?

ANSWER :

ANSI format does not mean US-ASCII. It means that the file is saved in one of the ANSI Code pages. Depending on your locale the default codepage might be different. Your text was probably encoded in the Windows-1254 codepage.

Leave a Reply

Your email address will not be published.