How to encode a dataset to UTF-8 in SAS studio?

[Mayt]

Hi everyone!

I have connected SAS code to SQLserver but the dataset  can't display Thai character. But when I have tried connecting SAS code to PostgreSQL, it works  and displays Thai character perfectly fine. However I need to connect with SQLserver. Please advise me. Thank you in advance.

My code:

libname sslib1 sqlsvr noprompt="DRIVER=SAS ACCESS to MS SQL Server;
UID=my UID ;PWD=my Password;
HOST=My host ;PORT=My port; schema=dbo";

And some columns  appear like this:

Any Thai character appears as � 

While the dataset connected with PostGreSQL

I have tried 

1.

libname sslib1 sqlsvr noprompt="DRIVER=SAS ACCESS to MS SQL Server;
UID=my UID ;PWD=my Password;
HOST=My host ;PORT=My port; client_encoding='UTF-8'; schema=dbo";

2. or add

proc options option=encoding;
run;

3. or create a new table

proc sql;
create table work.test(encoding='utf8') as
SELECT * FROM sslib1.mytable(encoding='utf8');
quit;

But still Thai characters appears as � 

[JosvanderVelden]

What is the encoding used in the sas session? Is sqlserver running on windows or unix? Is sas running on windows?

[Mayt]

- Encoding used in the sas session is UTF8
- SQLserver is running on windows
- SAS is running on unix