we are currently in the process of migrating latin1 databases to UTF8 in a MySQL Server. We are investigating what is the best approach and hopefully without an
I have a line of code that alters text temperature<-as.numeric(gsub("°.*","",temp)) R does not like the "°" character. When I save the file it says
I need to import an SAS Transfer File (.xpt) to MySQL. Because I don't own SAS, I tried a) first importing the .xpt in R b) then using dbWriteTable from the li