Data type

data type / 欄位型態

types of data

• IP(v4):
  • varchar(15)
  • ex: 255.255.255.255
  • range/limit:
• IP range - Classless inter-domain routing (CIDR)
  • 12 or 24 bytes (IPv4 and IPv6 networks)
  • ex: 69.208.0.0/32

• Chinese name:
  • 最長姓名有13個字
• unix timestamp:
  • bigint(10) ;
  • ex: 1328664539
  • range/limit:

• School ID defined by MOE at Taiwan / 學校代碼
  • integer: 4(university) ~ 6
  • ex: 0001(國立政治大學)、373607(臺北市立華江國小)。前面可能有零。
  • range/limit:

• 經緯度 (經度,緯度):
  • DECIMAL(18,12) or FLOAT( 10, 6 )
  • ex: 37.401724,-122.114646
  • range/limit:

• 價錢/金額
  • DECIMAL(10,2)
  • ex:
  • range/limit: 0.00 ~ 99999999.99

• 台灣縣市 下拉式選單

$city = array("基隆市", "台北市", "新北市", "桃園縣", "新竹市", "新竹縣", "苗栗縣", "台中市", 
        "彰化縣", "南投縣", "雲林縣", "嘉義市", "嘉義縣", "台南市", "高雄市", "屏東縣", "台東縣", "花蓮縣", 
        "宜蘭縣", "澎湖縣", "金門縣", "連江縣", "馬來西亞", "日本", "中國大陸", "其它" );

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

further reading

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