Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Advice on variable length character field
Message
De
03/01/2002 07:44:27
 
Information générale
Forum:
Visual Basic
Catégorie:
SQL Server
Divers
Thread ID:
00600152
Message ID:
00600197
Vues:
14
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform