Displaying 1 result from an estimated 1 matches for "the_database".
2018 Mar 14
1
Problem with reading data from an UTF-16 database
...;?' 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_Belgium.1252
LC_MONETAR...