I changed the default collation of my SQL Server 2022 database (and all string objects that already existed) to Latin1_General_100_CI_AS_SC_UTF8
.
Unfortunately, LINQ to SQL seems unable to handle this collation. Inserts seem to work fine, but updates fail. As far as I can see in the error log I still seem to be using an old SQL provider (SQL Server 2008) so the UTF8 collations are probably not supported yet.
My Winforms application was created long ago with VS 2010 and in the meantime I’m using VS2022 (Community edition).
I have already updated all data context objects but I still get corrupt German umlaut characters and most updates keep failing.
Do I explicitly have to change the SQL provider? If yes – how can I do so?
awba is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
6