BookmarkSubscribeRSS Feed
manishiiita
Quartz | Level 8

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..

1 REPLY 1
jimbarbour
Meteorite | Level 14

@manishiiita wrote:

 

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


I think you've probably identified the issue right there.  I think you need to change the encoding of the database so that it matches, at least that's the first thing that I would try.

 

The alternative is to experiment with the various encoding options.  Here's a recent paper that discusses some of the options:  https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4530-2020.pdf

 

Jim

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1489 views
  • 0 likes
  • 2 in conversation