RODBC on an Oracle Database and special characters

653 views Asked by At

Sorry if I ask a question that has already been ask, I effectively found some similar questions (like Special characters and RODBC for example) in this forum but no answer help me...

So, my problem is that when I make a query on an Oracle database, via RODBOC in R, I can't see correctly the special characters in return. R automatically convert (when it can) special characters to normal characters

Here is a simple test that I made :

> Cnx <- odbcConnect(dsn="myDSN", uid="myLogin",pwd="myPassword")
> sqlQuery(Cnx, paste("SELECT 'eéèêëÄÊÍÕØ' col FROM DUAL"))
         COL
1 eeeeeAEI??

I'm under Win7 x64, "myDSN" is an ODBC connection which uses the "Oracle in OraClient12home1" (64 bits). I use "R x64 3.2.0" with RODBC package version 1.3-11. The database is on linux server, is NLS_CHARACTERSET is "WE8MSWIN1252"

I've made other tests to understand better :

  • Same test with an ODBC connection which uses the "Oracle in OraClient12home1_32bit" with "R i386 3.2.0" => Same problem
  • Same test with an ODBC connection on local SQL server => No problem, I can see the specials characters
  • Same query with the same ODBC connection in MS Excel => No problem too

I tried to play with the DBMSencoding parameter, with "UTF-8" I get the same problem, with others, I get different errors...

Here is my sessionInfo()

R version 3.2.0 (2015-04-16)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1

locale:
[1] LC_COLLATE=French_France.1252  LC_CTYPE=French_France.1252 LC_MONETARY=French_France.1252
[4] LC_NUMERIC=C                   LC_TIME=French_France.1252    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] RODBC_1.3-11

loaded via a namespace (and not attached):
[1] tools_3.2.0

Thank's for your help

0

There are 0 answers