14,954
edits
Data type: Difference between revisions
Jump to navigation
Jump to search
no edit summary
mNo edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
data type | data type | ||
== types of data == | |||
* IP(v4): | * IP(v4): | ||
** varchar(15) | ** varchar(15) | ||
** ex: 255.255.255.255 | ** 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> | ||
* name: | * Chinese name: | ||
** 最長姓名有13個字 | ** 最長姓名有13個字 <ref> [http://dailynews.sina.com/bg/tw/twpolitics/chinanews/20101104/00481967448.html 台灣“獨一姓氏”者達149人 最長姓名有13個字_台灣頻道_新浪網-北美]</ref> | ||
* unix timestamp: | |||
* unix timestamp | ** bigint(10) ; limit? | ||
** bigint(10) | * 經緯度 (經度,緯度): | ||
** | ** 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 | |||
== references == | |||
<references /> | |||
further reading | == further reading == | ||
* [http://dev.mysql.com/doc/refman/5.0/en/data-types.html MySQL :: MySQL 5.0 Reference Manual :: 10 Data Types] | * [http://dev.mysql.com/doc/refman/5.0/en/data-types.html MySQL :: MySQL 5.0 Reference Manual :: 10 Data Types] | ||
[[Category:Web_Dev]] | [[Category:Web_Dev]] | ||