SQL to RGui | Character Encoding Issue

139 Views Asked by At

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.

1

There are 1 best solutions below

0
On BEST ANSWER

I don't know why it worked but I added fileEncoding="UTF-8-BOM" and it worked.