Data viewer incorrectly displays TEXT field as BLOB

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
toaster-loss
Posts: 6
Joined: Wed 14 Oct 2015 13:20

Data viewer incorrectly displays TEXT field as BLOB

Post by toaster-loss » Mon 20 Mar 2017 18:37

I have table which has a column of data type TEXT, as shown in the table editor. The table's character set is utf8mb4 and the table's collation is utf8mb4_bin. There are no overriding collation settings on the row itself, or any other row in the table.

When I go to view the data in dbForge it shows the column as BLOB(196605), and does not display the contents of the column, but instead a little file icon with bits.

I have changed the encoding in database connection properties, but I still can't get that field to display properly. I've tried utf8, utf8mb4, utf8 for MySQL, and Detect MySQL character set.

Is this an issue solvable from within dbForge, or is this something I will have to solve on my end, potentially by changing the collation on the table?

alexa

Re: Data viewer incorrectly displays TEXT field as BLOB

Post by alexa » Tue 21 Mar 2017 16:38

Indeed, the data from collation *_bin is counted as binary.

You could try changing the collation of the table or column in order to resolve the issue.

Post Reply