title: Datatype to Store Longitude/Latitude in Mysql
body: <pre><code>'43.005895','-71.013202'
  </code></pre>
  
  <p>Trying to use:</p>
  
  <pre><code>INSERT INTO table(fanDetLocZip, fanDetLocCity, fanDetLocState, fanDetLocLat, fanDetLocLong, fanDetLocTZ, fanDetLocDST)  
  VALUES(00210, 'Portsmouth', 'NH', '43.005895', '-71.013202', -5, 1);
  </code></pre>
  
  <p>I'm currently using the datatype <code>SPATIAL</code>, <code>GEOMETRY</code>.</p>
  
  <p>Its giving me errors like:  </p>
  
  <p>Cannot get geometry object from data you send to the GEOMETRY field</p>
  
  <p>All the values have 2 digits, and 6 decimal places after decimal. How do I store this in mysql?  </p>
  
  <p>Error I get when I use:<br>
  <code>INSERT INTO Table(fanDetLocZip, fanDetLocCity, fanDetLocState, fanDetLocLatLong, fanDetLocTZ, fanDetLocDST)<br>
  VALUES(00210, 'Portsmouth', 'NH', point(43.005895,-71.013202), -5,1)</code></p>
  
  <p>Error Image:<img src="https://i.stack.imgur.com/lFvH5.png" alt="img5"></p>