Technology Stack - EBS (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center