Data type: Difference between revisions

From LemonWiki共筆
Jump to navigation Jump to search
Line 21: Line 21:
** data type:
** data type:
** ex: 2001:0db8:85a3:08d3:1319:8a2e:0370:7344
** ex: 2001:0db8:85a3:08d3:1319:8a2e:0370:7344
* 網址
** data type: >= MySQL 5.0.3 use {{kbd | key=VARCHAR(2083)}}<ref>[http://stackoverflow.com/questions/219569/best-database-field-type-for-a-url sql - Best database field type for a URL - Stack Overflow]</ref>; {{kbd | key=nvarchar(2083)}} for MS SQL
** [http://support.microsoft.com/kb/208427 最大 URL 長度是在 Internet Explorer 中的 2,083 字元] for {{IE}}<ref>
* [http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers http - What is the maximum length of a URL in different browsers? - Stack Overflow]
* [http://wiert.me/2010/04/20/maximum-url-lengths/ Maximum URL lengths « The Wiert Corner – irregular stream of stuff]
</ref>


* Chinese name:  
* Chinese name:  

Revision as of 18:34, 20 August 2013

資料表欄位設計時，不同資料建議採用的資料型態(data type)


Web site design and development process


examples of data and suggested datatype

  • birth year
    • data type: int
    • ex: 1905 ~ 2013
    • range/limit: 108 yeas old[1][2]


  • IP(v4):
    • varchar(15)
    • ex: 255.255.255.255 [3]
    • range/limit:
  • IP range - Classless inter-domain routing (CIDR)[4]
    • 12 or 24 bytes (IPv4 and IPv6 networks)[5]
    • ex: 69.208.0.0/32
  • Chinese name:
    • 最長姓名有13個字 [8]
    • LINE姓名欄位長度限制: 15字(15個中文字或15英文字母)
  • unix timestamp:
    • bigint(10) ;
    • ex: 1328664539
    • range/limit:
  • School ID defined by MOE at Taiwan / 學校代碼[9]
    • integer: 4(university) ~ 6
    • ex: 0001(國立政治大學)、373607(臺北市立華江國小)。前面可能有零。
    • range/limit:
  • 經緯度 (經度,緯度):
    • DECIMAL(18,12)[10] or FLOAT( 10, 6 )[11]
    • ex: 37.401724,-122.114646
    • range/limit:
  • 價錢/金額
    • DECIMAL(10,2)[12]
    • ex:
    • range/limit: 0.00 ~ 99999999.99
  • 台灣縣市欄位值 下拉式選單[13]
$city = array("基隆市", "台北市", "新北市", "桃園縣", "新竹市", "新竹縣", "苗栗縣", "台中市", 
        "彰化縣", "南投縣", "雲林縣", "嘉義市", "嘉義縣", "台南市", "高雄市", "屏東縣", "台東縣", "花蓮縣", 
        "宜蘭縣", "澎湖縣", "金門縣", "連江縣");
  • 密碼
    • varchar 允許最小8個字元長度[14]
 (left blank intentionally)
* data
** data type
** ex:
** range/limit:

comparision of datatypes in different database server

Storing Unicode text[15]

  • MySQL: varchar
  • MS SQL 2008: nvarchar

DATETIME: ex: "2013-06-13 03:33:33"

  • MS SQL 2008, MySQL is equivalent

TIMESTAMP: MS SQL 2008 and MySQL is NOT equivalent[16] Icon_exclaim.gif

  • MS SQL 2008[17] ex: 0x00000000000007D3
  • MySQL ex: 2013-06-13 03:33:33

references

  1. ↑ Range from 1905 ~ 2013 (108 yeas old) from the Sing-up form from outlook.com [Last visited: 2013-02-04]
  2. ↑ 最年長者 - 維基百科，自由的百科全書: 「根據金氏世界紀錄大全紀錄的最長壽者是活了122年的雅娜·卡爾曼特」
  3. ↑ Datatype for storing ip address in SQL Server - Stack Overflow
  4. ↑ Help:Range blocks - MediaWiki
  5. ↑ PostgreSQL: Documentation: Manuals: Network Address Types
  6. ↑ sql - Best database field type for a URL - Stack Overflow
  7. ↑
  8. ↑ 中國新聞網 (2010). 台灣“獨一姓氏”者達149人 最長姓名有13個字_台灣頻道_新浪網-北美
  9. ↑ 各級學校名錄--教育部統計處 Department of Statistics[Last visited: 2012-02-16]
  10. ↑ mysql - What is the ideal data type for latitude / longitude? - Stack Overflow
  11. ↑ Creating a Store Locator with PHP, MySQL & Google Maps - Google Maps API Family - Google Code
  12. ↑ sql - Best Data Type for Currency - Stack Overflow[Last visited: 2012-03-07]
  13. ↑ 取自中華郵政全球資訊網
  14. ↑ Password length & complexity - OWASP "Minimum length. Passwords should be at least eight (8) characters long."
  15. ↑
  16. ↑ SQL Server 2008 timestamp data type - Stack Overflow
  17. ↑ timestamp (Transact-SQL)

further reading

Retrieved from "https://wiki.planetoid.info/index.php?title=Data_type&oldid=12342"