[MonetDB.R] Non ascii characters

[Anthony Damico]

i believe the problem is that € is latin encoding and monetdb needs UTF-8
encoding?

On Fri, Oct 23, 2015 at 3:46 PM, Mārcis Bratka <marcis.bratka at gmail.com>
wrote:

> 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
>
> _______________________________________________
> Monetr-users mailing list
> Monetr-users at lists.r-forge.r-project.org
> http://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/monetr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.r-forge.r-project.org/pipermail/monetr-users/attachments/20151024/bdee3f76/attachment.html>