Data viewer incorrectly displays TEXT field as BLOB
Posted: 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?
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?