How to store Arabic Characters in ORACLE database?

[Rohullah]

Hello All,

I am new to oracle database , please guide me how to configure my oracle database to store
Arabic Characters, please tell me all parameters that i should set to what value, step by step.

Thanks in advance.

Looking forward for your kindly Replay.

Best Regard
Rohullah Amiree

[ThatITdude]

Hi Rohullah,

Change the characterset of the database to AL32UTF8 and you should be able to store pretty much anything.

Regards,
Sumeet Singh

[Rohullah]

Hi Dear ThatITdude,
i have changed my oracle DB Character set to (AL32UTF8) as bellow but again the arabic characters are not appears right, it is appears as (??????) in sqlplus.

so please guide me how to do it ,thanks and regards

ORACLE instance shut down.
SQL> STARTUP MOUNT
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1292036 bytes
Variable Size 209717500 bytes
Database Buffers 394264576 bytes
Redo Buffers 7094272 bytes
Database mounted.
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

System altered.

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

System altered.

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

System altered.

SQL> ALTER DATABASE OPEN;

Database altered.

SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;

Database altered.

SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1292036 bytes
Variable Size 213911804 bytes
Database Buffers 390070272 bytes
Redo Buffers 7094272 bytes
Database mounted.
Database opened.