title: SQL Server latitude and longitude data type
body: <p>I want to ask about what SQL Server data type to use for storing latitude and longitude.</p>
  
  <p>Here's an example:</p>
  
  <pre><code>Latitude: -7.39755000
  Longitude: 107.80627000
  </code></pre>
  
  <p>If data type <code>decimal</code>, it won't save because SQL Server said: </p>
  
  <blockquote>
    <p>cannot convert numeric data to numeric</p>
  </blockquote>
  
  <p>as I remembered.</p>
  
  <p>But if type data was <code>float</code>, SQL Server will convert <code>0</code> so the latitude will be <code>-7.39755000</code>. So I figure it out replace the last <code>0</code> with <code>1 - 9</code>. is it the location will be not accurate? </p>
  
  <p>Or maybe stick with <code>decimal</code>, but how to avoid the warning?</p>