<div dir="ltr">i believe the problem is that € is latin encoding and monetdb needs UTF-8 encoding?<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Oct 23, 2015 at 3:46 PM, Mārcis Bratka <span dir="ltr"><<a href="mailto:marcis.bratka@gmail.com" target="_blank">marcis.bratka@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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 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 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 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>
<br>_______________________________________________<br>
Monetr-users mailing list<br>
<a href="mailto:Monetr-users@lists.r-forge.r-project.org">Monetr-users@lists.r-forge.r-project.org</a><br>
<a href="http://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/monetr-users" rel="noreferrer" target="_blank">http://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/monetr-users</a><br>
<br></blockquote></div><br></div>