<div dir="ltr"><div>Hi,<br><br></div>does MonetDB.R support non ascii characters? I get error when running following lines:<br><div><div><br>testDf1 <- data.frame(test = 'āčēģļč')<br>testDf2 <- data.frame(test = '€')<br><br>dbWriteTable(conn, "testDf1", testDf1)<br>dbWriteTable(conn, "testDf2", testDf2)<br><br><br><pre tabindex="0" class="" id="rstudio_console_output" style="font-family:Consolas;font-size:8pt!important;outline:medium none;border:medium none;margin:0px;white-space:pre-wrap!important;line-height:12px;color:rgb(0,0,0);font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;word-spacing:0px;background-color:rgb(255,255,255)"><span class="" style="color:rgb(197,6,11)">Error in .local(conn, statement, ...) :
Unable to execute statement 'INSERT INTO testDf2 VALUES ('€')'.
Server says '!invalid start of UTF-8 sequence'.</span></pre><br><br></div><div><pre tabindex="0" class="" id="rstudio_console_output" style="font-family:Consolas;font-size:8pt!important;outline:medium none;border:medium none;margin:0px;white-space:pre-wrap!important;line-height:12px;color:rgb(0,0,0);font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;word-spacing:0px;background-color:rgb(255,255,255)">R version 3.2.2 (2015-08-14)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1
locale:
[1] LC_COLLATE=Latvian_Latvia.1257 LC_CTYPE=Latvian_Latvia.1257 LC_MONETARY=Latvian_Latvia.1257
[4] LC_NUMERIC=C LC_TIME=Latvian_Latvia.1257
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] readr_0.2.1 dplyr_0.4.3 MonetDB.R_0.9.7 digest_0.6.8 DBI_0.3.1
loaded via a namespace (and not attached):
[1] lazyeval_0.1.10 magrittr_1.5 R6_2.1.1 assertthat_0.1 parallel_3.2.2 tools_3.2.2
[7] Rcpp_0.12.1 </pre><br><br></div><div>Thanks<br></div><div>Marcis<br></div></div></div>