Your data are stored with one of three formats: UTF-8; UTF-16; UTF-32. It's important that your driver and driver manager use the same format. If they don't use the same format, then you may see output that is unreadable. For example, your database catalog may only show the first letter of each table.
ODBC Driver
By default all RStudio Professional Drivers use UTF-16. You can check driver encoding in <driver>/bin/lib/rstudio.<odbc-data-source>.ini.
[Driver]
ErrorMessagesPath=
LogLevel=0
LogPath=
DriverManagerEncoding=UTF-16
Driver Manager
Your driver manager (unixODBC) uses UTF-16 unless it has been compiled with the DSQL_WCHART_CONVERT flag. You can check the existence of the flag by running odbc_config --cflags. If you see the DSQL_WCHART_CONVERT flag, then set DriverManagerEncoding=UTF-32 in the rstudio.<odbc-data-source>.ini file.
See Configure the Driver and Data Source for more information.
Comments