Search This Blog

Monday, December 12, 2016

Oracle and PHP: Using Bangla in Oracle and PHP (Unicode)

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);
   ?>

No comments:

Post a Comment