data type in SQL
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3858
Printed Date: 29 March 2026 at 6:17pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: data type in SQL
Posted By: the boss
Subject: data type in SQL
Date Posted: 26 June 2003 at 4:26pm
|
in access we set a coloum data type as Numeric and its feild size as double..what is its equivalent in SQL server 2000 |
Replies:
Posted By: ljamal
Date Posted: 26 June 2003 at 5:22pm
|
float ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: the boss
Date Posted: 26 June 2003 at 6:08pm
float doest work..messes up my data 
|
Posted By: Gullanian
Date Posted: 26 June 2003 at 6:13pm
| Well depends what kind of numbers your gonna store, you wont need more than long probably, which ranges from -2.15 billion to 2.15 billion. |
Posted By: the boss
Date Posted: 26 June 2003 at 6:58pm
|
well im storing IP numbers in the coloumb and wrong type of type afect the mathematical calculation of converted ip 2 ipnumber lookup...and therefore i get errors like data type conversion error and sh*t.., i tried varchar and none works..i remember i had a prefect runing database i made earlier but i deleted it and now forgot wht type of data types i used |
Posted By: Gullanian
Date Posted: 27 June 2003 at 11:59am
| if your storing IPS use char. In your code you can then cut up all the sections of the IP address and use the cInt() on each section before performing calculations |
Posted By: the boss
Date Posted: 28 June 2003 at 12:31am
| varchar (50) work for me perfect.. earlier i tried varchat (255) and it just kept showing me errors in my ASP page but varchar(50) throw no error when i access the data via my asp page |