MySQL import: JSON with binary character set

This is where the ad would go. Instead though, I'd like to point you towards my GitHub Sponsors page. If you're a regular reader and my content is helping you, you can consider a one-time or monthly sponsorship. If you're a company looking for dedicated ad placements on this blog or my newsletter, you can email me at brendt@stitcher.io

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:

Find: (X'[^,\)]*'), and replace by: CONVERT($1 using utf8mb4)

Source: StackOverflow.