Le mercredi 03 février 2016 à 11:44 -0800, Terry Seaward a écrit : > From R, it seems like the encoding is based on the connection (as > opposed to being hard coded). See `enc <- attr(channel, "encoding")` > below: > > ``` > [...] > > Digging down `odbcConnect` is just a wrapper for `odbcDriverConnect` > which has the following parameter `DBMSencoding = ""`. This calls the > `C` function `C_RODBCDriverConnect` (available here:RODBC_1.3- > 12.tar.gz), which has no reference to encodings. So `attr(channel, > "encoding")` is simply `DBMSencoding`, i.e. `""`. > > It seems to come down to `iconv(..., to = "")` which, from the R > source code, uses `win_iconv.c` attached. I can't seem to find how > `""` is handled, i.e. is there some default value based on the > system? "" refers to the encoding of the current system locale. This is a reasonable guess, but it will probably be wrong in many cases (else, R wouldn't have provided this option at all).
Regards