Difference between revisions of "Data type"

From LemonWiki共筆
Jump to navigation Jump to search
Line 40: Line 40:
  
 
* [http://dev.mysql.com/doc/refman/5.0/en/data-types.html MySQL :: MySQL 5.0 Reference Manual :: 10 Data Types]
 
* [http://dev.mysql.com/doc/refman/5.0/en/data-types.html MySQL :: MySQL 5.0 Reference Manual :: 10 Data Types]
 +
* [http://www.databaseanswers.org/data_models/index.htm Library of Free Data Models from DatabaseAnswers.org] {{access | data=2012-02-23}}
  
 
[[Category:Web_Dev]]
 
[[Category:Web_Dev]]

Revision as of 10:38, 23 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: 0001(國立政治大學)、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