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]
No comments:
Post a Comment