Invalid characters from Azure Synapse tables

[AlanCGIC]

I use the following libname statement in EG 8.3 when connecting to a schema  (ST_DIST) in Azure Synapse:

libname ST_DIST SQLSVR Datasrc=Synapse_PROD_Pool01 SCHEMA=ST_DIST readbuff=32767 insertbuff=32767 User=&azsynusr. Password="&azsynpss" ;

When I browse the tables, there are invalid characters instead of trademark symbols and emdashes. 

The collation field for the Azure Synapse tables is set to SQL_Latin1_General_CP1_CI_AS

What do I need to do in SAS to fix this problem?

[SASKiwi]

This is likely caused by an encoding mismatch between Synapse and SAS. I would start by checking the encoding of your SAS session. Please run this and post the results:

proc options option = encoding;
run;

[AlanCGIC]

Here is the current encoding for SAS:

ENCODING=LATIN1