Data type

data type

types of data

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

 (left blank intentionally)
data
** data type
** ex:
** range/limit:

further reading

• MySQL :: MySQL 5.0 Reference Manual :: 10 Data Types