MySQL import: JSON with binary character set 2018-01-09
If you see this error when importing MySQL files:
cannot create a JSON value from a string with CHARACTER SET 'binary'
You should find and replace parts of the import file with the following regex:
(X'[^,\)]*'), and replace by:
CONVERT($1 using utf8mb4)
This is where the ad would go
I get it, ads are stupid. I even feel dirty putting them here. But to be honest, they actually make a difference. So maybe you'd consider whitelisting this blog?