I have a .NET application that connects to a MySQL database using the MySql.Data.EntityFramework and MySql.Data NuGet packages (version 8.0.19). Recently, the MySQL database was updated to version 8.0.27, which apparently dropped support for the utf8mb3 character set, causing my application to throw the following error:
Character set 'utf8mb3' is not supported by .Net Framework.
I tried updating the NuGet packages to the latest version (8.0.32) as suggested in the documentation. It worked just fine, but that would require updating all of my applications, which is not feasible at the moment.
Is there a way to connect to the updated MySQL database using the old utf8mb3 character set, or is there an alternative solution that would allow me to continue using the old MySQL connector version without updating all my applications?
Thanks in advance for any help!
