14,957
edits
Data type: Difference between revisions
Jump to navigation
Jump to search
m
→經緯度 (經度,緯度)
(→價錢/金額) |
m (→經緯度 (經度,緯度)) |
||
| Line 55: | Line 55: | ||
=== 經緯度 (經度,緯度) === | === 經緯度 (經度,緯度) === | ||
* DECIMAL(18,12)<ref>[http://stackoverflow.com/questions/159255/what-is-the-ideal-data-type-for-latitude-longitude mysql - What is the ideal data type for latitude / longitude? - Stack Overflow]</ref> or FLOAT( 10, 6 )<ref>[http://code.google.com/apis/maps/articles/phpsqlsearch.html Creating a Store Locator with PHP, MySQL & Google Maps - Google Maps API Family - Google Code]</ref> | * DECIMAL(18,12)<ref>[http://stackoverflow.com/questions/159255/what-is-the-ideal-data-type-for-latitude-longitude mysql - What is the ideal data type for latitude / longitude? - Stack Overflow]</ref> or FLOAT( 10, 6 )<ref>[http://code.google.com/apis/maps/articles/phpsqlsearch.html Creating a Store Locator with PHP, MySQL & Google Maps - Google Maps API Family - Google Code]</ref> or VARCHAR( 30 ) | ||
* ex: 37.401724,-122.114646 | * ex: 37.401724,-122.114646 | ||
* range/limit: | * range/limit: | ||