MySqlException: Character set 'utf8mb3' is not supported by .Net Framework.

The following error occurred.

I replaced RustDedicated_Data/Managed/MySql.Data.dll and it worked.

https://dev.mysql.com/downloads/connector/net/  (mysql-connector-net-8.0.30-noinstall/v4.8)

Is there a problem?

MySql handle raised an exception in 'PlayerDatabase v1.6.2' plugin (MySqlException: Character set 'utf8mb3' is not supported by .Net Framework.) at MySql.Data.MySqlClient.CharSetMap.GetCharacterSet (MySql.Data.Common.DBVersion version, System.String CharSetName) [0x00033] in <8d7380b3d3cf4bd8be324c584f371b44>:0 at MySql.Data.MySqlClient.CharSetMap.GetEncoding (MySql.Data.Common.DBVersion version, System.String CharSetName) [0x00000] in <8d7380b3d3cf4bd8be324c584f371b44>:0 at MySql.Data.MySqlClient.Driver.Configure (MySql.Data.MySqlClient.MySqlConnection connection) [0x001a1] in <8d7380b3d3cf4bd8be324c584f371b44>:0 at MySql.Data.MySqlClient.MySqlConnection.Open () [0x00198] in <8d7380b3d3cf4bd8be324c584f371b44>:0 at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x00059] in <6e6f659265ef431ea12ea404a5e9a54c>:0(08:10:03) | MySql handle raised an exception in 'PlayerDatabase v1.6.2' plugin (NullReferenceException: Object reference not set to an instance of an object) at MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery (System.IAsyncResult asyncResult) [0x00022] in <8d7380b3d3cf4bd8be324c584f371b44>:0 at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery(System.IAsyncResult) at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x000f2] in <6e6f659265ef431ea12ea404a5e9a54c>:0

The error means your database is using an unsupported character set, as mentioned by the error.

My mysql
Server version: 8.0.30
It does support utf8mb3.

Old MySql.Data.dll is the cause.

I'm sure your database server may support it, but that doesn't matter if the connector doesn't. If manually updating solves the issue for you, then by all means, replace it.

Thanks for the reply, I replaced the MySql.Data.dll and the error is gone and it looks fine for now.

Hello, sorry for reviving this topic, but why don’t you want to update the outdated MySQL connector (MySql.Data.dll) version 6.9.5, which was released on November 26, 2014, to a newer one? I (and not only me) have issues with INSERT IGNORE queries. I installed the latest version (9.2.0), and this issue was gone. However, many hostings restrict access to DLL files, making it impossible to manually replace the connector.

 

MySql handle raised an exception (NullReferenceException: Object reference not set to an instance of an object)
  at MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery (System.IAsyncResult asyncResult) [0x00022] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery(System.IAsyncResult)
  at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x000f2] in <021a1dba6a754e42a6cc7771fdfee190>:0


Merged post

INSERT ... ON DUPLICATE KEY UPDATE results in the same error