SQL> conn sys 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 ####### bytes
.
.
.
.
Database mounted.
Database opened.
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 ####### bytes
.
.
.
.
Database mounted.
Database opened.
Now , you can insert BANGLA in Oracle Database.
Again, you need to access from PHP front end. You have to add character set in PHP connection file.
I used below line:
<?php
$db_charset = 'AL32UTF8';
$con = oci_connect('nano', 'nan786', '192.168.1.111/nandb',$db_charset);
?>
Connected.
SQL>
SQL>
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup restrict;
ORACLE instance started.
Total System Global Area ####### bytes
.
.
.
.
Database mounted.
Database opened.
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 ####### bytes
.
.
.
.
Database mounted.
Database opened.
Now , you can insert BANGLA in Oracle Database.
Again, you need to access from PHP front end. You have to add character set in PHP connection file.
I used below line:
<?php
$db_charset = 'AL32UTF8';
$con = oci_connect('nano', 'nan786', '192.168.1.111/nandb',$db_charset);
?>
No comments:
Post a Comment