title: Mysql doesn't store properly my zerofilled values
body: <p>I am having a very strange issue.  I am trying to upload a little over 6800 items to a table from an xlsx file.  It goes through 41 items perfectly but the 42<sup>nd</sup> item gets the wrong UPC loaded into the table.  The next 890ish items all get the same UPC even though inside my PHP script the correct UPC is shown and output to the screen.</p>
  <p>This is my script:</p>
  <pre><code>
  error_reporting(E_ALL);
  
  require_once '../vendor/autoload.php';
  require_once '../config/AI_Toolbox.php';
  require_once '../config/namespacedDatabase.php';
  
  use AI\Toolbox\AI_Toolbox;
  use nsDatabase\namespacedDatabase;
  use PhpOffice\PhpSpreadsheet;
  
  $toolbox = new AI_Toolbox();
  $database = new namespacedDatabase();
  $db = $database-&gt;getConnection();
  
  $reader = new PhpOffice\PhpSpreadsheet\Reader\Xlsx();
  $reader-&gt;setReadDataOnly(true);
  
  $spreadsheet = $reader-&gt;load(__dir__ . '/insert.xlsx');
  
  $sheet = $spreadsheet-&gt;getSheet($spreadsheet-&gt;getFirstSheetIndex());
  $data = $sheet-&gt;toArray();
  
  //$toolbox-&gt;prettyPrint($data);
  
  
  foreach ($data as $datum)
  {
      $toolbox-&gt;prettyPrint($datum);
  //    var_dump($datum);
      $name = $datum[0];
      $model = $datum[1];
      $upc = $datum[2];
      $subcategory = $datum[4];
      $manufacturer = $datum[3];
  
      $productInsert = &quot;INSERT INTO `redacted`.redacted2
                                  (manufacturer_id, subcategory_id, product_name, product_model, product_upc)
                                VALUES
                                  (:mid,:sid,:pin,:pim,:piu)&quot;;
      echo &quot;&lt;strong&gt;UPC &lt;/strong&gt;&quot;;
      $toolbox-&gt;prettyPrint($upc);
  //    var_dump($upc);
      $insertPrepped = $db-&gt;prepare($productInsert);
      $insertPrepped-&gt;bindValue(':mid', $manufacturer, PDO::PARAM_INT);
      $insertPrepped-&gt;bindValue(':sid', $subcategory, PDO::PARAM_INT);
      $insertPrepped-&gt;bindValue(':pin', $name);
      $insertPrepped-&gt;bindValue(':pim', $model);
      $insertPrepped-&gt;bindValue(':piu', $upc, PDO::PARAM_INT);
  $toolbox-&gt;prettyPrint($upc);
  //            $toolbox-&gt;prettyPrint($insertPrepped);
      $results = $insertPrepped-&gt;execute();
  $toolbox-&gt;prettyPrint($upc);
      if ($results === true)
      {
          echo &quot;&lt;div&gt;&lt;strong&gt;Product $name, with upc: $upc Inserted Successfully&lt;/strong&gt;&lt;/div&gt;&lt;br/&gt;&quot;;
      } else
      {
          echo &quot;&lt;div&gt;&lt;strong&gt;Failed to Insert $name, with upc $upc &lt;/strong&gt;&lt;/div&gt;&lt;br/&gt;&quot;;
      }
  
      unset($name, $model, $upc, $subcategory, $manufacturer);
  }
  </code></pre>
  <p>Here is an example of the spreadsheet right where the issue begins:</p>
  <p><a href="https://i.stack.imgur.com/p9kQF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/p9kQF.png" alt="Page Output" /></a></p>
  <p>As you can see it has the correct UPC but when it Inserts into the database it inserts like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ProductId</th>
  <th>manufacturerId</th>
  <th>subcategoryId</th>
  <th>productName</th>
  <th>ProductModel</th>
  <th>productUPC</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>42</td>
  <td>4</td>
  <td>21</td>
  <td>TETON 20&quot; BOYS BIKE</td>
  <td></td>
  <td>4294967295</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I have tried everything I can think of, moving the item to the end of the file, changing the file from xlsx to csv and back, changing the columns. Nothing I have done has worked, the 42<sup>nd</sup> item gets the wrong UPC</p>