title: How to store longitude and latitude in database. MySQL won't go further than -99.9999999
body: <p>Ok right now I'm storing lat and lng columns as <code>DECIMAL(10,8)</code></p>
  
  <p>I'm trying to insert this:</p>
  
  <p><code>-117.1779216</code> However it keeps inserting as this : <code>-99.99999999</code></p>
  
  <p>Why is this? I see every other board storing it as DECIMAL, but it won't go back more when I'm giving it 10 places before the period... So I would think it could go -117.. None of them are marked as <code>unsigned</code> either.</p>