topic Re: how to export accented characters (french characters) from sas to oracle? in New SAS User https://communities.sas.com/t5/New-SAS-User/how-to-export-accented-characters-french-characters-from-sas-to/m-p/554698#M9550 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/270351">@jerathashutosh</a>&nbsp;wrote:<BR /> <P>sorry for the super late reply <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P> <P>&nbsp;</P> <P>I saw that article before and my oracle server is using the&nbsp;AL32UTF8 characterset and our sas server is on LATIN1 characterset.</P> <P>&nbsp;</P> <P>I tried to change the characterset of my SAS dataset to utf8 and then loading it to oracle, that didn't work either.</P> <P>&nbsp;</P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> <P>Did you try changing the encoding setting for the SAS session (not any individual dataset)?&nbsp;</P> <P>&nbsp;</P> <P>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.</P> Mon, 29 Apr 2019 13:51:30 GMT Tom 2019-04-29T13:51:30Z how to export accented characters (french characters) from sas to oracle? https://communities.sas.com/t5/New-SAS-User/how-to-export-accented-characters-french-characters-from-sas-to/m-p/550414#M8784 <P>Hi There,</P><P>&nbsp;</P><P>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".</P><P>&nbsp;</P><P>How to fix this?</P><P>&nbsp;</P><P>Thanks.</P><P>&nbsp;</P><P>Ashu</P> Thu, 11 Apr 2019 20:36:00 GMT https://communities.sas.com/t5/New-SAS-User/how-to-export-accented-characters-french-characters-from-sas-to/m-p/550414#M8784 jerathashutosh 2019-04-11T20:36:00Z Re: how to export accented characters (french characters) from sas to oracle? https://communities.sas.com/t5/New-SAS-User/how-to-export-accented-characters-french-characters-from-sas-to/m-p/550731#M8845 <P>Let us know if this SAS Note might help&nbsp;<A href="http://support.sas.com/kb/51/411.html" target="_blank">http://support.sas.com/kb/51/411.html</A></P> Fri, 12 Apr 2019 17:25:13 GMT https://communities.sas.com/t5/New-SAS-User/how-to-export-accented-characters-french-characters-from-sas-to/m-p/550731#M8845 SAS_Cares 2019-04-12T17:25:13Z Re: how to export accented characters (french characters) from sas to oracle? https://communities.sas.com/t5/New-SAS-User/how-to-export-accented-characters-french-characters-from-sas-to/m-p/554695#M9548 <P>sorry for the super late reply <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P>&nbsp;</P><P>I saw that article before and my oracle server is using the&nbsp;AL32UTF8 characterset and our sas server is on LATIN1 characterset.</P><P>&nbsp;</P><P>I tried to change the characterset of my SAS dataset to utf8 and then loading it to oracle, that didn't work either.</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 29 Apr 2019 13:44:21 GMT https://communities.sas.com/t5/New-SAS-User/how-to-export-accented-characters-french-characters-from-sas-to/m-p/554695#M9548 jerathashutosh 2019-04-29T13:44:21Z Re: how to export accented characters (french characters) from sas to oracle? https://communities.sas.com/t5/New-SAS-User/how-to-export-accented-characters-french-characters-from-sas-to/m-p/554698#M9550 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/270351">@jerathashutosh</a>&nbsp;wrote:<BR /> <P>sorry for the super late reply <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P> <P>&nbsp;</P> <P>I saw that article before and my oracle server is using the&nbsp;AL32UTF8 characterset and our sas server is on LATIN1 characterset.</P> <P>&nbsp;</P> <P>I tried to change the characterset of my SAS dataset to utf8 and then loading it to oracle, that didn't work either.</P> <P>&nbsp;</P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> <P>Did you try changing the encoding setting for the SAS session (not any individual dataset)?&nbsp;</P> <P>&nbsp;</P> <P>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.</P> Mon, 29 Apr 2019 13:51:30 GMT https://communities.sas.com/t5/New-SAS-User/how-to-export-accented-characters-french-characters-from-sas-to/m-p/554698#M9550 Tom 2019-04-29T13:51:30Z Re: how to export accented characters (french characters) from sas to oracle? https://communities.sas.com/t5/New-SAS-User/how-to-export-accented-characters-french-characters-from-sas-to/m-p/554732#M9563 <P><SPAN>Holy!! I</SPAN><SPAN>&nbsp;looked at our servers and there is indeed a utf8 server. used that one and it worked!!</SPAN></P><P>&nbsp;</P><P><SPAN>Thanks <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></SPAN></P><P>&nbsp;</P><P><SPAN>How to change the encoding setting for the SAS session, just curious?</SPAN></P><P>&nbsp;</P><P><SPAN>Regards,</SPAN></P><P><SPAN>Ashu</SPAN></P> Mon, 29 Apr 2019 15:10:24 GMT https://communities.sas.com/t5/New-SAS-User/how-to-export-accented-characters-french-characters-from-sas-to/m-p/554732#M9563 jerathashutosh 2019-04-29T15:10:24Z