Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Saving space with Varchar
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01345228
Message ID:
01345231
Vues:
25
No, you'll not save space. The varchar data type in VFP is stored the same way as char data type. The only difference is that varchar is padded with CHR(0) and char is padded with spaces.
The varchar was introduced mainly for compatibility with MS SQL server.

>I thought the varchar field type would save space in the file size of my table?
>
>I have a table that has thousands of records and many character fields, I thought by changing the character fields to varchar the table size would be reduced?
>
>Have I got this all wrong?
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform