c# - System.NotSupportedException:.Net Framework 不支持字符集“utf8mb3”
问题描述
我正在尝试使用 MySQL 数据库运行服务器,但是我不断收到这个巨大的错误,我不知道为什么。
[21:15:49,107] Server Properties Lookup: Error While Initialization
DOL.Database.DatabaseException: Table DOL.Database.ServerProperty is not registered for Database Connection...
at DOL.Database.ObjectDatabase.SelectAllObjects[TObject]()
at DOL.GS.ServerProperties.Properties.get_AllDomainProperties()
at DOL.GS.ServerProperties.Properties.InitProperties()
at DOL.GS.GameServer.InitComponent(Action componentInitMethod, String text)```
also this error
[21:15:35,991] ExecuteSelectImpl: UnHandled Exception for Select Query "DESCRIBE `Specialization`"
System.NotSupportedException: Character set 'utf8mb3' is not supported by .Net Framework.
at MySql.Data.MySqlClient.CharSetMap.GetCharacterSet(DBVersion version, String charSetName)
at MySql.Data.MySqlClient.MySqlField.SetFieldEncoding()
at MySql.Data.MySqlClient.NativeDriver.GetColumnData(MySqlField field)
at MySql.Data.MySqlClient.NativeDriver.GetColumnsData(MySqlField[] columns)
at MySql.Data.MySqlClient.Driver.GetColumns(Int32 count)
at MySql.Data.MySqlClient.ResultSet.LoadColumns(Int32 numCols)
at MySql.Data.MySqlClient.ResultSet..ctor(Driver d, Int32 statementId, Int32 numCols)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlDataReader.Close()
at MySql.Data.MySqlClient.MySqlCommand.ResetReader()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at DOL.Database.SQLObjectDatabase.ExecuteSelectImpl(String SQLCommand, IEnumerable`1 parameters, Action`1 Reader)```
解决方案
更新到 8.0.28 版(NuGet 包MySql.Data
)后,一切都恢复正常了。
推荐阅读
- .net - 添加新的 NuGet 包时如何解决 OutOfMemoryException 错误?
- listview - 如何在 ListView onClick 中将图像切换为文本
- python - 在Python中将JSON字符串数组转换为对象数组
- android - Google Git 上的 Android 源代码库的结构是什么?
- php - 如果已经在输入值中,如何不回显一个值?
- ruby-on-rails - 我应该如何将 React 与 Rails 集成?
- javascript - 我如何填充画布而不是圆圈
- jquery - 获取隐藏字段的值
- postgresql - 为什么插入主键不影响顺序?
- javascript - 使用 ajax 和 javascript 更新 innerHTML 值