Data type: Difference between revisions
Jump to navigation
Jump to search
m (→types of data) |
(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:
(left blank intentionally) data ** data type ** ex: ** range/limit:
references
- ↑ Datatype for storing ip address in SQL Server - Stack Overflow
- ↑ Help:Range blocks - MediaWiki
- ↑ PostgreSQL: Documentation: Manuals: Network Address Types
- ↑ 台灣“獨一姓氏”者達149人 最長姓名有13個字_台灣頻道_新浪網-北美
- ↑ 各級學校名錄--教育部統計處 Department of Statistics[Last visited: 2012-02-16]
- ↑ mysql - What is the ideal data type for latitude / longitude? - Stack Overflow
- ↑ Creating a Store Locator with PHP, MySQL & Google Maps - Google Maps API Family - Google Code