[MonetDB.R] Non ascii characters

[Mārcis Bratka]

Hi,

does MonetDB.R support non ascii characters? I get error when running
following lines:

testDf1 <- data.frame(test = 'āčēģļč')
testDf2 <- data.frame(test = '€')

dbWriteTable(conn, "testDf1", testDf1)
dbWriteTable(conn, "testDf2", testDf2)


Error in .local(conn, statement, ...) :
  Unable to execute statement 'INSERT INTO testDf2 VALUES ('€')'.
Server says '!invalid start of UTF-8 sequence'.



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



Thanks
Marcis
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.r-forge.r-project.org/pipermail/monetr-users/attachments/20151023/b8a9eb85/attachment.html>