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.

Things I wish I knew when I started programming

This is my newest book aimed at programmers of any skill level. This book isn't about patterns, principles, or best practices; there's actually barely any code in it. It's about the many things I've learned along the way being a professional programmer, and about the many, many mistakes I made along that way as well. It's what I wish someone would have told me years ago, and I hope it might inspire you.

Read more

Comments

Loading…

No comments yet, be the first!