how to export accented characters (french characters) from sas to oracle?

[jerathashutosh]

Hi There,

i have a sas dataset where in one column i have accented character, e.g. "Montréal North". When i export this value to oracle it comes like "Montr� North".

How to fix this?

Thanks.

Ashu

[SAS_Cares]

Let us know if this SAS Note might help http://support.sas.com/kb/51/411.html

[jerathashutosh]

sorry for the super late reply 😞

I saw that article before and my oracle server is using the AL32UTF8 characterset and our sas server is on LATIN1 characterset.

I tried to change the characterset of my SAS dataset to utf8 and then loading it to oracle, that didn't work either.

[Tom · Accepted solution]

---

@jerathashutosh wrote:

sorry for the super late reply 😞

I saw that article before and my oracle server is using the AL32UTF8 characterset and our sas server is on LATIN1 characterset.

I tried to change the characterset of my SAS dataset to utf8 and then loading it to oracle, that didn't work either.

---

Did you try changing the encoding setting for the SAS session (not any individual dataset)? 

The encoding needs to be set at session startup. So either use a different command to launch SAS or if you are using SAS/Studio or Enterprise Guide connect to a different server that is configured to use UTF8.

[jerathashutosh]

Holy!! I looked at our servers and there is indeed a utf8 server. used that one and it worked!!

Thanks 😄

How to change the encoding setting for the SAS session, just curious?

Regards,

Ashu