Displaying 1 result from an estimated 1 matches for "our_serv".
Did you mean:
our_server
2018 Mar 14
1
Problem with reading data from an UTF-16 database
...characters like '?' and '?' are
returned as '?'. I've added the sessionInfo() output from both machines.
Any suggestions on how to fix the problem?
Best regards,
Thierry
library(DBI)
con <- dbConnect(odbc::odbc(), .connection_string =
"Driver=the_drive;Server=our_server;Database=the_database;Trusted_Connection=Yes;")
dbGetQuery(con, sql_statement)
R version 3.4.2 (2017-09-28)
Platform: i386-w64-mingw32/i386 (32-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1
Matrix products: default
locale:
[1] LC_COLLATE=Dutch_Belgium.1252 LC_CTYPE=Dutch...