Data type: Difference between revisions

Data type (edit)

130 bytes added , 7 February 2012

14,957

edits

@@ Line 5: / Line 5: @@
 ** varchar(15)
 ** 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:
 * Chinese name:
 ** 最長姓名有13個字 <ref> [http://dailynews.sina.com/bg/tw/twpolitics/chinanews/20101104/00481967448.html 台灣“獨一姓氏”者達149人 最長姓名有13個字_台灣頻道_新浪網-北美]</ref>
 * unix timestamp:
-** bigint(10) ; limit?
+** bigint(10) ;
+** ex:
+** range/limit:
 * 經緯度 (經度,緯度):
 ** DECIMAL(18,12)<ref>[http://stackoverflow.com/questions/159255/what-is-the-ideal-data-type-for-latitude-longitude mysql - What is the ideal data type for latitude / longitude? - Stack Overflow]</ref> or FLOAT( 10, 6 )<ref>[http://code.google.com/apis/maps/articles/phpsqlsearch.html Creating a Store Locator with PHP, MySQL & Google Maps - Google Maps API Family - Google Code]</ref>
 ** ex: 37.401724,-122.114646
+** range/limit:
+<pre> (left blank intentionally)
+data
+** data type
+** ex:
+** range/limit:
+</pre>
 == references ==