Retrieved data shows mangled characters
Posted: Tue 06 Dec 2016 01:28
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.
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.
