title: Data truncated for column 'diameter' at row 1 on Mysql
body: <p>Getting an error while trying to insert data into Mysql Table using datamapper ( Codeigniter )</p>
  
  <pre><code>Data truncated for column 'diameter' at row 1
  INSERT INTO `purchases` (`bills_id`, `products_id`, `quantity`, `diameter`, `lena`, `lenb`, `lenr`, `thicka`, `thickb`, `widtha`, `widthb`, `boxes`, `resulta`, `resultb`) VALUES (1, 28, '2', '', '', '', '', '', '', '', '', '1', '', 2)
  </code></pre>
  
  <p>Here is the screenshot of the table</p>
  
  <p><a href="https://i.stack.imgur.com/O6epf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/O6epf.png" alt="Screenshot"></a></p>