encoding issue while reading sql database

[sangavis37]

When our customer tries to read an sql database that has latin1 characters, in sas (with utf-8 session encoding), it displays question mark in place of those characters. I suggested this https://communities.sas.com/t5/SAS-Communities-Library/Change-Encoding-using-SAS-Enterprise-Guide-Wi... but it did not help. Anyone has any idea how we can resolve this? Thank you in advance.

data xxxx;
  set xxxx;
  where xx like '%ë%';
run;

[Ksharp]

Change your SAS encoding to be the same with sql database. Like : WLATIN1

[Patrick]

You could try if the proposed approach from the following discussion works for you. https://stackoverflow.com/questions/58526418/reading-oracle-data-from-sas-in-a-utf-8-session-charact... 

[sangavis37]

They are using oledb to connect and encoding= option does not seem to available for oledb