store link, such as www.yahoo.com

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

store link, such as www.yahoo.com

Author

Topic

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2005-11-11 : 02:55:04

Can I store link into a table, such as "www.yahoo.com"? What data type shold I select?

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-11-11 : 02:59:25

varchar (20)

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-11 : 03:00:03

Use Varchar data type
Refer in Books On Line, SQL Server help file for more information

Madhivanan

Failing to plan is Planning to fail

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-11-11 : 03:00:58

Then again, you have to ask yourself what are you really storing in the database column? Would it be domain names ? and what lenght ? But varchar would be appropriate

The lenght really is up to you

Afrika

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-11 : 03:01:10

quote:
Originally posted by afrika

varchar (20)

Not enough to store big links

Madhivanan

Failing to plan is Planning to fail

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-11-11 : 03:04:47

quote:
Originally posted by madhivanan

quote:
Originally posted by afrika

varchar (20)

Not enough to store big links

Madhivanan

Failing to plan is Planning to fail

quote:

Then again, you have to ask yourself what are you really storing in the database column? Would it be domain names ? and what lenght ? But varchar would be appropriate

The lenght really is up to you

Afrika

hi Boss,
refer to the post above