I have a long working code including a SQL chunk fetching data from a database with variable names that includes special characters (æøå).
select distinct variable_with_spec_char_ø from...
In Rstudio 1.3 it works without problems
In Rstudio 1.4 it fails and the log shows it likely is because of encoding problems when the SQL is send to the server
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '¸'
So "ø" is rendered and send to SQL server as "Ã¸"
with same setting Rstudio 1.3 was rendering/sending as "ø"
It works fine (as normal) when query dosn't contains special characters.
I have not been able to find a solution - hope there is a work around ?