Issue with Arabic Field in Oracle EBS
Hi Team
We are using sqlplus to extract data from the Oracle EBS table which has Arabic characters, but we are getting some weird types of characters "�?�?�?�? �?�?�?�?�?�?�?�? �?�?�?�?�?�?�?". I can see current in database when using SQLDeveloper
Here are more details
SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';
AR8ISO8859P6
also, we tried to use multiple export options in bash/shell/Unix before running sqlplus
like export NLS_LANG='.UTF8'
export LC_ALL="en_US.UTF-8"
export NLS_LANG="ARABIC_AR8ISO8859P6"
but still, we are getting weird values in place of Arabic characters. Please advise