Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Character vs Memo fields
Message
De
24/07/2008 09:26:32
 
 
À
23/07/2008 13:49:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01333464
Message ID:
01333726
Vues:
12
>>>I have never use varchar. Is it fair to say the primary difference between it and Character type is the absense of padding to the full field width? Does the byte cost vary with the actual contents of the field?
>>>Does varchar width establish the maxlength of the field contants?
>>
>>Varchar exists primarily for connecting to back-end databases that support the type. In a VFP table, the field length will still be fixed to the maximum; there's no saving in disk space. The only difference is that VFP handles the trimming automatically.
>>
>>Tamar
>
>Thanks Tamar
>That's about the way I figured it from reading the docs.
>Any thoughts on my original question?

It depends. Use character if most records will have data in the field, and you're sure you'll never need more than 254. Use memo if many records will have no data (or not much) or you don't know how large the field will be.

Tamar
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform