Data type: Difference between revisions

From LemonWiki共筆
Jump to navigation Jump to search
(add school id)
Line 16: Line 16:
** ex: 1328664539
** ex: 1328664539
** range/limit:
** range/limit:
School ID defined by MOE at Taiwan / 學校代碼<ref>[http://www.edu.tw/statistics/content.aspx?site_content_sn=25656 各級學校名錄--教育部統計處 Department of Statistics]{{access | date=2012-02-16}}</ref>
** integer: 4(university) ~ 6
** ex: 373607
** range/limit:
* 經緯度 (經度,緯度):  
* 經緯度 (經度,緯度):  
** 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>

Revision as of 11:23, 16 February 2012

data type

types of data

  • IP(v4):
    • varchar(15)
    • ex: 255.255.255.255 [1]
    • range/limit:
  • IP range - Classless inter-domain routing (CIDR)[2]
    • 12 or 24 bytes (IPv4 and IPv6 networks)[3]
    • ex: 69.208.0.0/32
  • Chinese name:
    • 最長姓名有13個字 [4]
  • unix timestamp:
    • bigint(10) ;
    • ex: 1328664539
    • range/limit:

School ID defined by MOE at Taiwan / 學校代碼[5]

    • integer: 4(university) ~ 6
    • ex: 373607
    • range/limit:
  • 經緯度 (經度,緯度):
    • DECIMAL(18,12)[6] or FLOAT( 10, 6 )[7]
    • ex: 37.401724,-122.114646
    • range/limit:
 (left blank intentionally)
data
** data type
** ex:
** range/limit:

references

further reading