Charset/Encoding Latin Character

Question

I am having problems reading txt files with column headings with Latin characters, such as: "ç".

My command used is:

spark_read_csv (sc = sc, path = "txtfile", charset = "latin1", name = "mydata", delimiter = ";", header = T)

When I look at mydata, the columns come out as follows:

• "Município" => "MunicApio"
• "Vínculo_Ativo" => "VAnculo_Ativo"