Fixing JSON errors after database conversion from MySQL 5.6 to 5.7
If you're migrating a database from MySQL 5.6 to 5.7, you might bump into issues with the JSON encoding of certain fields. This probably happens because only in MySQL 5.7, JSON columns are properly supported. The improved support for native JSON makes it more strict, which can cause errors after bumping the database version or after exporting and subsequently importing it.
Symfony
Written by Bob on January 14, 2021.