Today I’m going to talk about an error in strings when you have accents. If you have a word like this: baú in your database and in MicroStrategy you see something like ba?, for example. This is an Unicode problem. You have to set odbc connection to allow accents in your odbc.ini file.
Just go to:
In your odbc connection, change the default value of IANAAppCodePage to 111.
It will allow MicroStrategy to use Unicode for that specific database connection.
Hope it helps.
God bless you!