data type in SQL

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
the boss Members Profile Find Members Posts Senior Member Joined: 19 January 2003 Location: Saudi Arabia Status: Offline Points: 1727	Post Options Post Reply Quote the boss Report Post Thanks(0) Quote Reply Topic: data type in SQL 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

ljamal Members Profile Find Members Posts Mod Builder Group Joined: 16 April 2003 Status: Offline Points: 888	Post Options Post Reply Quote ljamal Report Post Thanks(0) Quote Reply Posted: 26 June 2003 at 5:22pm
	float
	L. Jamal Walton L. Jamal Inc : Web/ Print Design and ASP Programming

the boss Members Profile Find Members Posts Senior Member Joined: 19 January 2003 Location: Saudi Arabia Status: Offline Points: 1727	Post Options Post Reply Quote the boss Report Post Thanks(0) Quote Reply Posted: 26 June 2003 at 6:08pm
	float doest work..messes up my data

Gullanian Members Profile Find Members Posts Senior Member Joined: 04 January 2002 Location: England Status: Offline Points: 4373	Post Options Post Reply Quote Gullanian Report Post Thanks(0) Quote Reply 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.

the boss Members Profile Find Members Posts Senior Member Joined: 19 January 2003 Location: Saudi Arabia Status: Offline Points: 1727	Post Options Post Reply Quote the boss Report Post Thanks(0) Quote Reply 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 char float numeric 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

Gullanian Members Profile Find Members Posts Senior Member Joined: 04 January 2002 Location: England Status: Offline Points: 4373	Post Options Post Reply Quote Gullanian Report Post Thanks(0) Quote Reply 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

the boss Members Profile Find Members Posts Senior Member Joined: 19 January 2003 Location: Saudi Arabia Status: Offline Points: 1727	Post Options Post Reply Quote the boss Report Post Thanks(0) Quote Reply 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

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.