sql data type for latitude code example

Example 1: sql latlng

For longitudes use: Decimal(9,6), and latitudes use: Decimal(8,6)

Example 2: sql query to get column data type in sql

SELECT DATA_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE 
     TABLE_NAME = 'yourTableName' AND 
     COLUMN_NAME = 'yourColumnName'