Data type: Difference between revisions
Jump to navigation
Jump to search
m (→types of data) |
m (→types of data) |
||
| Line 32: | Line 32: | ||
** range/limit: 0.00 ~ 99999999.99 | ** range/limit: 0.00 ~ 99999999.99 | ||
* | * 台灣縣市欄位值 下拉式選單<ref>取自[http://www.post.gov.tw/post/internet/f_searchzone/index.jsp?ID=190103 中華郵政全球資訊網]</ref> | ||
<pre> | <pre> | ||
$city = array("基隆市", "台北市", "新北市", "桃園縣", "新竹市", "新竹縣", "苗栗縣", "台中市", | $city = array("基隆市", "台北市", "新北市", "桃園縣", "新竹市", "新竹縣", "苗栗縣", "台中市", | ||
Revision as of 09:09, 11 April 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(10,2)[8]
- ex:
- range/limit: 0.00 ~ 99999999.99
- 台灣縣市欄位值 下拉式選單[9]
$city = array("基隆市", "台北市", "新北市", "桃園縣", "新竹市", "新竹縣", "苗栗縣", "台中市",
"彰化縣", "南投縣", "雲林縣", "嘉義市", "嘉義縣", "台南市", "高雄市", "屏東縣", "台東縣", "花蓮縣",
"宜蘭縣", "澎湖縣", "金門縣", "連江縣");
(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
- ↑ sql - Best Data Type for Currency - Stack Overflow[Last visited: 2012-03-07]
- ↑ 取自中華郵政全球資訊網