title: data too long for this column mysql error
body: <p>Here's my query:</p>
  
  <pre><code>update slcm.m_user_master set Is_Active = '1' where M_USER_ID = '1'
  </code></pre>
  
  <p>while updating table it showing message data too long for this column .
  I have taken database IsActive database as bit.</p>
  
  <pre><code>this is table description
  e Table
  
  CREATE TABLE `m_user_master` (
    `M_USER_ID` int(11) NOT NULL AUTO_INCREMENT,
    `User_Type_ID` int(11) DEFAULT NULL,
    `M_User_Name` varchar(50) DEFAULT NULL,
    `M_User_Name_Hindi` varchar(50) DEFAULT NULL,
    `User_Login_ID` varchar(30) DEFAULT NULL,
    `User_Password` varchar(30) DEFAULT NULL,
    `User_Mobile_No` int(12) DEFAULT NULL,
    `User_Email_ID` varchar(50) DEFAULT NULL,
    `Created_Date` datetime DEFAULT NULL,
    `Updated_By` varchar(50) DEFAULT NULL,
    `Updated_Date` datetime DEFAULT NULL,
    `Is_Active` char(1) DEFAULT NULL,
    `Active_From` datetime DEFAULT NULL,
    `Active_To` datetime DEFAULT NULL,
    `Created_By` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`M_USER_ID`),
    KEY `FK_M_User_Master_M_User_Type_Master` (`User_Type_ID`),
    CONSTRAINT `FK_M_User_Master_M_User_Type_Master` FOREIGN KEY (`User_Type_ID`) REFERENCES `m_user_type_master` (`User_Type_ID`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8
  </code></pre>