Oracle UTF-8

Hello,

Most of times when we deployed our projects in some Cyrillic supported country we meet with problem to display properly. Thats why I am posting this solution here may be it saved your time.

Do not hesitate  to commenting :)

1) Enter from sqlplus / as sysdba
2)shutdown immediate

Database closed.
Database dismounted.
ORACLE instance shut down.
3) startup restrict
ORACLE instance started.

Total System Global Area 2.0602E+10 bytes
Fixed Size                  3842760 bytes
Variable Size            2751466808 bytes
Database Buffers         1.7784E+10 bytes
Redo Buffers               63262720 bytes
Database mounted.
Database opened.

4)alter database character set INTERNAL_USE AL32UTF8;

Database altered.

5)alter database character set AL32UTF8;

Database altered.

6) shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
7) startup
ORACLE instance started.

Total System Global Area 2.0602E+10 bytes
Fixed Size                  3842760 bytes
Variable Size            2751466808 bytes
Database Buffers         1.7784E+10 bytes
Redo Buffers               63262720 bytes
Database mounted.
Database opened.