'EF Core with MySQL connector incorrectly thinks utf8mb3 is in use
I'm thoroughly perplexed as to why my project thinks utf8mb3 is being used. I'm running MariaDB 10.6.5
The configuration being passed is setup with a connection string that doesn't contain the CharSet, although it did but I removed it to see if it made a difference. CharSet=utf8mb4 was being passed. This is the default my.ini charset and collation
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_520_ci
I had the database with no tables and it showed
I tried deleting the database and the CanConnect() call still complains about utf8mb3.
Does anyone know where this mysterious utf8mb3 is coming from when it's actually utf8mb4?
I'm on EF Core 3.1.22 as this is a netstandard 2.0 project. I'm restricted to this as this is an addon mod resource for FiveM which doesn't support newer than netstandard2.0 for the server code. I'm using MySql.Data.EntityFrameworkCore 8.0.22
The code is here https://github.com/HTB-FiveM/nfive-htb/tree/features/nfive. You can run the one test in the integration tests project, probably need to have mariadb installed.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|