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

Mayt — Wed, 04 Oct 2023 09:08:48 GMT

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

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 �

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

JosvanderVelden — Wed, 04 Oct 2023 10:03:35 GMT

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

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

Mayt — Thu, 05 Oct 2023 06:40:58 GMT

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

topic Re: How to encode a dataset to UTF-8 in SAS studio? in SAS Programming

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

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

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