title: Encoding special characters SQL to R and back
body: <p>I have a problem passing data from R to SQL and then reading it back
  The original data is from some excel files and have the following word: <code>Průmyslový</code></p>
  
  <p>Using <code>latin1</code> for encoding depreciates the u within the word <code>Prumyslový</code></p>
  
  <p>Using <code>latin2</code> for encoding changes the accent of the u <code>Prùmyslový</code></p>
  
  <p>Which encoding could i use?
  I am using an MS SQL 2016 server and the package <code>DBI</code> and usually the following code where the word is part of the data frame that I am writing to the server.</p>
  
  <p>I am not using <code>UTF-8</code> because then <code>öffentlicher</code> becomes <code>Ã¶ffentlicher</code></p>
  
  <pre><code>DBI::dbConnect(odbc::odbc(),
                        Driver = "SQL Server",
                        Server = "DBABMZ0006", 
                        Database = "EA_DB",
                        encoding = "latin1")
  
  DBI::dbWriteTable(con,
                    Tabelle,
                    df_temp,
                    append=TRUE)
  
  df_test&lt;-DBI::dbReadTable(con,
                            Tabelle)
  </code></pre>