After running a query and saving the results to a .txt file, when I open that txt file by double clicking on it, everything is OK, there is no issue with Turkish characters. Like this:
TRİKO
After making the R read the txt with read.csv, then I encounter this:
TRÄ°KO
I use SQL Server 2014 Express and I think my collation isn't the problem.
The thing is when I copy the content in that txt file and paste it to a new txt file that I created, R reads it just fine. I again see the capital i with the dot on top.
What am I doing wrong here?
Thanks.
I don't know why it worked but I added
fileEncoding="UTF-8-BOM"
and it worked.