what is best suited Data type for mobile no. , longitude and latitude??in Mysql And oracle
+1
A:
I am going to guess, varchar(16) or longer for mobile no, number(5,3) or longer for Longitude / Latitude ?
Andrew Keith
2009-10-05 06:15:42
+5
A:
Since you're not likely to do arithmetic or compare mobile numbers (except for equality) string type seems best. Length of the string depends on the phone number
You might consider converting longitude and latitude to decimal values and just using a float.
pavium
2009-10-05 06:18:21
Never use numeric types to store phone numbers. In Australia at the very least, phone numbers can start with '0' which gets stripped if you use a numeric type.
Matthew Scharley
2009-10-05 06:29:51
(I realise you don't advocate using a numeric type, I'm just trying to enforce the "Why?" of the choice).
Matthew Scharley
2009-10-05 06:31:15