Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Field size - max varchar (8000)

Status
Not open for further replies.

tcardoso

Programmer
Jan 31, 2005
56
PT
Hi,

I'm kind of noob in SQL Server... I use SQL Server 2000. I have a field that is varchar (8000) left from another coder, but now I need it to have more size, but max varchar is 8000...

What should I use?

Thanks
Telmo Cardoso
 
text

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP
 
Read up on text before you use it, it may require special handling.

SQL Server 2005 has a better way of handling larger data, so it might be a good reason to upgrade if this is a field that will have frequent need to access.

"NOTHING is more important in a database than integrity." ESquared
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top