UTF8 saving problem

[Tore]

My app saves data to a MySQL database as well as retrieving data from the db. The db is set up with utf8 character set for text variables and retrieving data returns special characters (like the Scandinavian letters) fine. However, when saving such characters from the app they are not stored correctly in the db. Error messages during the R session indicates a utf8 issue. My app uses the DBI, pool and dplyr libraries. Thanks in advance for any help. Kind regards Tore

[andresrcs]

Could you make a minimal REPRoducible EXample (reprex) about your issue?
Here is a very useful guide about how to make a reprex for a shiny app

Shiny debugging and reprex guide

Shiny issues can be challenging to resolve relative to other problems with your code or statistical methods. Shiny apps are often large, complex projects with interacting files. When seeking help from others it is considered polite to: First, do your best to work through RStudio's debugging tools to diagnose your issue on your own. Often those shiny logs and tracebacks are useful to others trying to help out. Second, strive to minimize the effort required to replicate your issue. You can do this with a reproducible example ("reprex"). Shiny Debugging Errors in Shiny code can be difficult to track down. If you don't know where your problem is coming from, you can track it down with some o…

Also, could you post the logs of your app to have a better understanding of what you're problem is?

[DavoWW]

Looks like your strings are not being Encoded correctly either before output, or on-the-fly during the
output writing process.

Check your session options() and the following help pages (not run):

options("encoding")
# ?Encoding
# ?write.csv (example of on-the-fly encoding)
# ?file

# This GitHub  page has a good discussion of the issues:

https://github.com/tidyverse/readr/issues/697

HTH