DreamsCoder.com

We Code your Dreams
home > database programs

How to store and display regional languages code in PHP MySql





How to store and display regional languages code in PHP MySql

Write these statements before execting Query

@mysql_query("SET NAMES 'utf8'"); 	
@mysql_query("SET CHARACTER_SET utf8");

include this tag in HTML page

/*To display regional language format */

Label - database





Creating Table in MySql



mysql> create table BRC_2(B_no int primary key,B_name varchar(25) NOT NULL,
B_city varchar(25))engine=innodb;
Query OK, 0 rows affected (0.01 sec)

mysql> desc BRC_2;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| B_no   | int(11)     |      | PRI | 0       |       |
| B_name | varchar(25) |      |     |         |       |
| B_city | varchar(25) | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+

3 rows in set (0.00 sec)

Label - database





next page >






Privacy Policy
Copyright © 2018 by DreamsCoder. All Rights Reserved.
DreamsCoder Google Plus DreamsCoder Facebook



Latest Technology,Tricks and Tips