cyberfly
9/21/2018 - 2:33 AM

Mysql fix Cannot create a JSON value from a string with CHARACTER SET 'binary'.

After export from Sequel Pro and want to reimport, face this problem

create a JSON value from a string with CHARACTER SET 'binary'.

I had this problem dealing with exports made by Sequel Pro. I unchecked the Output BLOB fields as hex option and the problem went away. Visually inspecting the export showed legible JSON instead of binary.

https://stackoverflow.com/a/49544119/417899