Using the inline editor for JSON columns can result in the MysqlDataTruncation problem.
Solution:
In the connection tab check Buffer All Rows for a Result and connect again.
MySQL: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Cannot create a JSON value from a string with CHARACTER SET 'binary' Print
Modified on: Wed, 12 Jun, 2024 at 3:54 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.