How to Resolve \'System.NotSupportedException: Character set \'utf8mb3\' is not supported by .Net Framework\' Error When Using MySQL?

"System.NotSupportedException: Character set 'utf8mb3' is not supported by .Net Framework" Error: A Resolution

Problem:

When attempting to run a server with a MySQL Database, users encounter a lengthy error:

**[21:15:49,107] ExecuteSelectImpl: Unhandled Exception for Select Query "DESCRIBE Specialization"
System.NotSupportedException: Character set 'utf8mb3' is not supported by .Net Framework.**

Additionally, an error message related to registration of the DOL.Database.ServerProperty table for the Database Connection is displayed.

Solution:

The underlying cause of this issue is an outdated version of the MySQL Connector/NET.

Resolution:

1. Update the MySQL Connector/NET package to version 8.0.28 or later.
2. Install the updated package using NuGet: MySql.Data.

Verified Fix:

After implementing the update, both errors should be resolved, and the server will run properly with the MySQL Database.

The above is the detailed content of How to Resolve \'System.NotSupportedException: Character set \'utf8mb3\' is not supported by .Net Framework\' Error When Using MySQL?. For more information, please follow other related articles on the PHP Chinese website!