I am using EF Core on .Net 5 web application. The database is on SQL Server Express version 11.0.2100. Default collation is set to SQL_Latin1_General_CP1_CI_AS. All relevant fields are using nvarchar.
I seed my database by reading some data from a json file embedded in assembly. for example an array of countries like;
{
"Name": "Réunion",
"Code": "RE",
"RegionName": "Africa",
"RegionCode": 2
}, ... more data
Notice the accented é character. When it gets saved, the DB shows it as a question mark( � ). But if I go to sql management studio and manually edit the field, it gets stored properly.
I am wondering whether something is going wrong with EF Core when saving data? Has anyone come across this problem? This issue seems close but it's for MySQL.
