Brent • 1/9/2018

MySQL import: JSON with binary character set

This article provides a solution for the MySQL import error "cannot create a JSON value from a string with CHARACTER SET 'binary'". It explains how to fix the import file by using a specific regex find-and-replace pattern to convert the problematic strings to the utf8mb4 character set, with a source link to StackOverflow.

0 comments

#json #mysql #Import