Brent • 1/9/2018

MySQL import: JSON with binary character set

Read Original

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
MySQL import: JSON with binary character set

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
React vs Browser APIs (Mental Model)
Jivbcoop • 4 votes
2
React, useEffect, and Stale Closures: How to Avoid Them with Dependencies and useRef
Jivbcoop • 3 votes
3
Building Type-Safe Compound Components
TkDodo Dominik Dorfmeister • 2 votes
4
Dew Drop – January 15, 2026 (#4583)
Alvin Ashcraft • 1 votes
5
Using Browser Apis In React Practical Guide
Jivbcoop • 1 votes
6
Better react-hook-form Smart Form Components
Maarten Hus • 1 votes
7
Building a Complete FIRE Calculator App with GitHub Copilot in One Chat Session
James Montemagno • 1 votes