Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wallaceoc
Starting Member
1 Post |
 Posted - 2005-02-07 : 15:24:15
|
| I am designing a table that will have two columns for gps coordinates. One for longitude and one for latitude. I don't know which data type I should use for this information. I was thinking either real or float.I don't want the database to change the figure if it has less than 5ish digits after the decimal point. If it has more than that then it can round it off.Which data type should I use?Thanks for your help,Wallace |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-02-07 : 15:42:47
|
| Use varchar...but are the points for?Don't you need a thrid column to define what the point is?Like your house?And then what?Are you going to use two points to determine distance?Brett8-) |
 |
|
|
Xerxes
Aged Yak Warrior
666 Posts |
Posted - 2005-02-07 : 15:45:20
|
| While we're at it, Brett, could you explain instances wherein you would prefer float over decimal, numeric over real, nvarchar over varchar?Semper fi, Xerxes, USMC (Ret) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-07 : 16:13:52
|
| Float should be used for floating point numeric data only. nvarchar should be used for unicode data to support multi languages. Decimal and numeric are the same thing. Never used real before, but real and float are similar.Tara |
|
|
|
|
|
|
data type