non english colnames make error when db_insert_into

tidyverse
,
1

When non english colnames(korean charater), cannot db_insert_into. . .
I couldn't find any solution :frowning:

library(tidyverse)
library(RSQLite)
df<-data.frame(가=1:3)
con<-dbConnect(SQLite(),'mydb.sqlite')
copy_to(con,df, 'tbl1')
df2<-data.frame(가=4:6)
db_insert_into(con,'tbl1',df2)
# error message such as
# tolower(colnames)... multybyte string ...
2

Hi hwericsatie, I found you some resources that might help set you on your way until someone else offers a full solution. Hopefully these might help solve your encoding issue. I'm no expert on this one!

2 Likes
3

Thank you for your help:)

4

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.