I'm facing issues with Arabic data.
Task: I'm reading data from a CSV file and finally, appending it to Oracle table. CSV file contains data in Arabic & English languages.
Steps followed:
I've further checked and found below encoding of SAS (UTF-8) & Oracle (AL32UTF8).
Can someone please help in above issue. Please let me know if you need any further information. Thank you in advance for your help.
That's eventually an issue with your current setting for NLS_LANG
https://support.sas.com/resources/papers/proceedings17/SAS0296-2017.pdf
"In Oracle table, Arabic characters are showing as garbage"
It could also be an issue with the client you're using to look at the data. ...but first I'd check NLS_LANG
That's eventually an issue with your current setting for NLS_LANG
https://support.sas.com/resources/papers/proceedings17/SAS0296-2017.pdf
"In Oracle table, Arabic characters are showing as garbage"
It could also be an issue with the client you're using to look at the data. ...but first I'd check NLS_LANG
@PatrickThank you for your quick reply.
Problem is resolved after setting export variables in sasenv_local file, as given in document.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.