Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.4
-
None
-
C# / ADO.NET (.NET 5.0)
MySql connector 8.0.X
Description
I am using C# (.NET 5.0) and the MySql connector (8.0.26) to query the information schema about database details. This worked fine with MariaDb 10.5
With MariaDb 10.6.4, I get an exception that utf8mb3 is not supported whenever I try to query anything from the information schema.
Here is an example code to reproduce the issue:
string sql = $@"SELECT SCHEMA_NAME FROM `information_schema`.`SCHEMATA` ";
MySqlCommand cmd = new MySqlCommand(sql, conn);
var reader = cmd.ExecuteReader();
This worked fine on MariaDb 10.5
See the attached file for the full example code. The MySql connector does not support uft8mb3 anymore. (It is deprecated by Oracle/MySql and won't be supported in the future).
I guess this issue is related to the fact that the information schema has now the collation uft8mb3 by default. I tried to configure my server that Uft8mb4 is the default collation for all databases, but I can't change the collation for the information schema:
Attachments
Issue Links
- is caused by
-
MDEV-8334 Rename utf8 to utf8mb3
- Closed
- relates to
-
MDEV-26105 MariaDB 10.6 cannot be used from C# client applications
- Closed
-
MDEV-26605 Creating table with primary key constraint name fails when using C# connector
- Open