Hello DBForge People,
When I go 'Retrieve Data' on a table with DBForge Studio for MySQL, I get mangled characters in the view of the data.
Something that should look like this:
(MTI) Mi’gmawe’l Tplu’taqnn Incorporated
...actually looks like this:
(MTI) Mi’gmawe’l Tplu’taqnn Incorporated
(it's a north american aboriginal name...it also happens with French accents)
I was beating my head against the wall trying to figure out what was wrong. It looks fine in Excel and MS Access. I thought maybe the import from either Access, Excel or plain CSV was getting the character set wrong, so I played with lots of different encodings for the database, etc.
It turns out though, after viewing the the same table with Navicat and Adminer, the data is intact and it's DBForge's view of it that is mangled.
Is there anything I can do to fix the data view being presented in DBForge?...I have version 7.1.31 Standard Edition.
Retrieved data shows mangled characters
Re: Retrieved data shows mangled characters
You can select 'utf8 -> Unicode (UTF-8)' on the 'Advanced' tab of the 'Database Connection Properties' dialog box that can be opened by right-clicking the connection in Database Explorer and selecting 'Modify Connection' from the popup menu.
Re: Retrieved data shows mangled characters
That fixed it, thanks!
Re: Retrieved data shows mangled characters
Thank you for updating us on this issue. Please let us know if any questions arise.