Image Caption

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]

No comments: