title: Importing 14 digit timestamp from CSV to MySQL and avoid stripping out data
body: <p>I'm creating a mySQL db that will contain as part of its data, timestamps.  These timestamps will be imported from a CSV file in which they appear like this - 20110701083231</p>
  
  <p>My question is which is the best datatype to store these as?</p>
  
  <p>In my attempts so far, during the import process (which I am doing via PHPMyAdmin) the end of the timestamp appears to get stripped out and they become 2011070000000.</p>
  
  <p>Oddly, when I return to the CSV file, the entries there also appeared to be stripped out in the same way...?</p>
  
  <p>Thanks in advance for any light you shed and for all previous help given.</p>