search

ankane / dbx

A fast, easy-to-use database library for R
Other
187 stars 15 forks source link

encoding problems with windows #29

Closed bpresentati closed 2 years ago

bpresentati commented 2 years ago

I'm building a workflow that takes an excel file that has special characters and is saved in utf-8 and uploads it to a mysql database where the fields are defined as utf8_general_ci. In R the encoding of the strings in the dataframes before I try to insert them into the DB is utf-8. However, when they make it onto the DB, they are somehow interpreted as the windows native standard and it seems as if there's nothing I can do about this if I'm using the dbx package. Would anyone have suggestions what I could try?

ankane commented 2 years ago

Hey @bpresentati, I haven't done much with encodings, but if you can create a minimal script to reproduce, I can try to look into it. Does it work as expected if you use DBI directly?