Using Bangla(Unicode) In Oracle Database.

Colelcted from : http://rajiboracle.blogspot.com/2014/01/using-banglaunicode-in-oracle-database.html





SQL> conn /as sysdba
Connected.
SQL>
SQL>
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP RESTRICT;
ORACLE instance started.

Total System Global Area  778387456 bytes
Fixed Size                  1374808 bytes
Variable Size             402654632 bytes
Database Buffers          369098752 bytes
Redo Buffers                5259264 bytes
Database mounted.
Database opened.
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

System altered.

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

System altered.

SQL> ALTER DATABASE CHARACTER SET AL32UTF8;

Database altered.

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

Total System Global Area  778387456 bytes
Fixed Size                  1374808 bytes
Variable Size             402654632 bytes
Database Buffers          369098752 bytes
Redo Buffers                5259264 bytes
Database mounted.
Database opened.

Now Check Using Bangla Using Toad 10.5 and  Avro Bangla keyboard.