Scout APM helps PHP developers pinpoint N+1 queries, memory leaks & more so you can troubleshoot fast & get back to coding faster. Start your free 14-day trial today.

MySQL import: JSON with binary character set

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.