title: Mysql truncates the data
body: <p>I can't upload data to mysql with csv upload.</p>
  
  <p>I got this error now:
  <a href="https://i.stack.imgur.com/M9dAr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/M9dAr.png" alt="enter image description here"></a></p>
  
  <p>It says duplicate entry for '7'. but it is not 7 actually. it is 907 in the csv file I'm trying to upload. Mysql takes only 7 of 907 for some reason. How can i solve this problem? please. thanks.
        -- phpMyAdmin SQL Dump
          -- version 4.6.4
          -- <a href="https://www.phpmyadmin.net/" rel="nofollow noreferrer">https://www.phpmyadmin.net/</a>
          --
          -- Host: 127.0.0.1
          -- Generation Time: Nov 04, 2018 at 11:27 AM
          -- Server version: 5.7.14
          -- PHP Version: 5.6.25</p>
  
  <pre><code>    SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
      SET time_zone = "+00:00";
  
  
      /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
      /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
      /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
      /*!40101 SET NAMES utf8mb4 */;
  
      --
      -- Database: `mdb`
      --
  
      -- --------------------------------------------------------
  
      --
      -- Table structure for table `ttb`
      --
  
      CREATE TABLE `ttb` (
        `Week` int(11) NOT NULL,
        `Date` date DEFAULT NULL,
        `Sside` varchar(45) DEFAULT NULL,
        `Schange` varchar(45) DEFAULT NULL,
        `SRep` tinyint(4) DEFAULT NULL,
        `SRepC` varchar(45) DEFAULT NULL,
        `Opp` varchar(45) DEFAULT NULL,
        `RuRpt` varchar(45) DEFAULT NULL,
        `RaRpt` varchar(45) DEFAULT NULL,
        `DuRpt` varchar(45) DEFAULT NULL,
        `DaRpt` varchar(45) DEFAULT NULL,
        `Dist1` varchar(15) DEFAULT NULL,
        `Dist2` varchar(15) DEFAULT NULL,
        `Dist3` varchar(15) DEFAULT NULL,
        `Dist4` varchar(15) DEFAULT NULL,
        `Dist5` varchar(15) DEFAULT NULL,
        `Distin` varchar(15) DEFAULT NULL,
        `Sint` varchar(15) DEFAULT NULL,
        `Svar` varchar(15) DEFAULT NULL,
        `Sdev` varchar(15) DEFAULT NULL,
        `Smean` varchar(15) DEFAULT NULL,
        `Smedian` varchar(15) DEFAULT NULL,
        `Rerng` varchar(15) DEFAULT NULL,
        `Bmedian` varchar(45) DEFAULT NULL,
        `Opp1` varchar(45) DEFAULT NULL,
        `Opp2` varchar(45) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  </code></pre>
  
  <p>and this is the beginning of CSV file that I want to upload:</p>
  
  <pre><code>906,24/10/2018,14,B,,7,,,,,x,4,,,2,3,4,1,2,1,1,1,0.3,,3,1
  905,17/10/2018,5,A,,5,,,R1,S1,2x,,3,,2,3,1,4,1,2,1,1,,3,3,2
  </code></pre>