Data type: Difference between revisions

Revision as of 18:35, 7 February 2012

data type

IP(v4):
- varchar(15)
- ex: 255.255.255.255 ^[1]
- range/limit:
Classless inter-domain routing (CIDR)^[2]
- 12 or 24 bytes (IPv4 and IPv6 networks)^[3]

Chinese name:
- 最長姓名有13個字 ^[4]
unix timestamp:
- bigint(10) ;
- ex:
- range/limit:
經緯度 (經度,緯度):
- DECIMAL(18,12)^[5] or FLOAT( 10, 6 )^[6]
- ex: 37.401724,-122.114646
- range/limit:

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

@@ Line 6: / Line 6: @@
 ** ex: 255.255.255.255 <ref>[http://stackoverflow.com/questions/1385552/datatype-for-storing-ip-address-in-sql-server Datatype for storing ip address in SQL Server - Stack Overflow]</ref>
 ** range/limit:
+* Classless inter-domain routing (CIDR)<ref> [http://www.mediawiki.org/wiki/Help:Range_blocks Help:Range blocks - MediaWiki] </ref>
+** 12 or 24 bytes (IPv4 and IPv6 networks)<ref> [http://www.postgresql.org/docs/8.2/static/datatype-net-types.html PostgreSQL: Documentation: Manuals: Network Address Types] </ref>
 * Chinese name:
 ** 最長姓名有13個字 <ref> [http://dailynews.sina.com/bg/tw/twpolitics/chinanews/20101104/00481967448.html 台灣“獨一姓氏”者達149人 最長姓名有13個字_台灣頻道_新浪網-北美]</ref>