Image Caption
Showing posts with label Store Multi language form. Show all posts
Showing posts with label Store Multi language form. Show all posts

Wednesday, August 8, 2012

Store Multi language form to mysql Database Table

1. Create New table to Store Multi language form 

-----Query to create table-----

CREATE TABLE ` TableName ` (

  `user_id` int(20) NOT NULL,
  `permissions` varchar(20) character set utf8 collate  utf8_bin default NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


2. Store Multi language form to Already Exit mysql table

1. Login to phpmyadmin
2. open the site database
3. Select Structure tab [Right side menu]

4. It show the list of cell in the table
5. Click the Check All link [Bottom of the listed cell ]
6. Click Change icon [right side to the check all link]
7. Change the all Collation column value to uft8_bin then click save [bottom]