topic Appending Arabic Data to Oracle Table in SAS Data Management

Appending Arabic Data to Oracle Table

manishiiita — Mon, 08 Jul 2019 12:32:38 GMT

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:

Read data from CSV using INFILE statement in Data step.
Data step created a SAS Dataset. Here, Arabic characters are visible properly.
Using Proc Append to push data from above SAS Dataset to Oracle table. In Oracle table, Arabic characters are showing as garbage.

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.

Patrick — Mon, 08 Jul 2019 12:40:37 GMT

That's eventually an issue with your current setting for NLS_LANG

"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

manishiiita — Mon, 08 Jul 2019 16:46:07 GMT

@PatrickThank you for your quick reply.

Problem is resolved after setting export variables in sasenv_local file, as given in document.