LemonWiki共筆

Data type

Revision as of 11:17, 7 February 2012 by Planetoid (talk | contribs)

data type

types of data

  • IP(v4):
    • varchar(15)
    • ex: 255.255.255.255 [1]
  • Chinese name:
    • 最長姓名有13個字 [2]
  • unix timestamp:
    • bigint(10) ; limit?
  • 經緯度 (經度,緯度):
    • DECIMAL(18,12)[3] or FLOAT( 10, 6 )[4]
    • ex: 37.401724,-122.114646

references

  1. ↑ Datatype for storing ip address in SQL Server - Stack Overflow
  2. ↑ 台灣“獨一姓氏”者達149人 最長姓名有13個字_台灣頻道_新浪網-北美
  3. ↑ mysql - What is the ideal data type for latitude / longitude? - Stack Overflow
  4. ↑ Creating a Store Locator with PHP, MySQL & Google Maps - Google Maps API Family - Google Code

further reading

Retrieved from "https://wiki.planetoid.info/index.php?title=Data_type&oldid=10693"