MySQL server now uses utf8mb3 rather than utf8 since version 8.0.29
The server now uses utf8mb3 in place of the alias utf8 for character set names when populating data dictionary tables from built-in character sets. This affects the display of character set and related information in the MySQL Information Schema tables listed here.
If you use an elder version of MySQL.Data connector for your project, you will get an error
Server Error in '/' Application. Character set 'utf8mb3' is not supported by .Net Framework.
Solution:
Upgrade MySQL.Data package to at least version 8.0.28 from NuGet, we recommend you use the latest version of MySQL.Data for your project if it is suitable. Then rebuild your project and republish it to the server end.
Article ID: 2224, Created: July 28, 2022 at 4:41 AM, Modified: July 28, 2022 at 4:44 AM