Starting with SQL Server 2019, there is a new collation named
Latin1_General_100_BIN2_UTF8
which seems to allow to use unicode-characters in traditional varchar-fields. Can you share any experience with columns using that collation? We access our database with the devArt dbExpress SQL Server drivers and are questioning ourselves if this might be a way to support unicode chars without changing everything to nvarchar.
Thank you and best regards,
Bastian