Your data are stored with one of three formats:
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.
By default all RStudio Professional Drivers use UTF-16. You can check driver encoding in
[Driver] ErrorMessagesPath= LogLevel=0 LogPath= DriverManagerEncoding=UTF-16
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
See Configure the Driver and Data Source for more information.