Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Advice on variable length character field
Message
From
03/01/2002 07:44:27
Guy Barrette
Lasalle, Quebec, Canada
 
General information
Forum:
Visual Basic
Category:
SQL Server
Title:
Re: Advice on variable length character field
Miscellaneous
Thread ID:
00600152
Message ID:
00600197
Views:
15
>Hi - I am familiar with the memo field type in vfp - basically it accomodates any length of characters... I wondered - what is the equivalent in SQL Server 2000... do I use varchar and set length to 8000?
>
>Regards
>
>Chris

Varchar is limited to 256 characters.
Use the TEXT datatype.
Guy Barrette, MCSD
============
Blog http://weblogs.asp.net/guybarrette
Microsoft Regional Director, Montreal, Canada www.microsoft.com/rd
MVP, ASP.NET http://mvp.support.microsoft.com/
President, Montreal Visual Studio User Group www.guvsm.net
INETA Regional Rep for Quebec www.ineta.org
UniversalThread Magazine Columnist (.NET Books Review Column) www.utmag.com
Tech Chair French Track, DevTeach 2004 & 2005 www.devteach.com
Business Architect, Microsoft Team - Nurun Inc www.nurun.com
XBox Live Gamer Tag: Slomo QC CA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform