Friday, February 28, 2014

Charecter set (UTF8) in oracle Database

If you want to show Bangla  to your website from database.you must set utf8 character to your Database. The process of setting utf8 character to Database:

First. 
#Sqlplus sys as sysdba
sql>Shutdown immediate;

Second.
#Sqlplus sys as sysdba
sql>startup mount;

Third.
sql>alter system enable restricted session;

Four.
sql>alter database open;

Five.
sql>ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;

ENJOY.

Welcome to my Blog

Hello 

I am Imran Hussain Heron from Bangladesh.I have been working on a software firm for 2 years. i share my knowledge and practical experience both.Please pray for me.Read my blog regularly.

Thanks.

Md. Imran Hussain Heron

RHCE, RHCSA,ORACLE DBA,ORACLE APPLICATION