We are facing issues with encoding for Accent & Diacritic characters, it is showing as Garbage Values.
We are using MS SQL Server DB (2013). Basically, we load data from other Data Warehouse through DI ETL Jobs. Within SAS Datasets, we are able to see these characters properly but post loading data into SQL Tables, it is showing as Garbage.
We are using UTF-8 encoding on SAS Server end. On SQL DB, the encoding is SQL_Latin1_General_CP850_CI_AS. Ideally, we should have UTF-8 encoding on DB side as well to resolve this issue and we tried using NVARCHAR column types for this but this didn't work.
Can you please assist to resolve this issue..