Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Varchar takes more diskspace than Character Type ?
Message
 
 
À
10/09/2008 10:56:54
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 SP1
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01346349
Message ID:
01346352
Vues:
10
>Dear All
>
>Somehow did not sound right to me but it is infact happening.
>
>Changed one large column (240 chars) from Character to Varchar and size on disc actually increased ???
>I was actually expecting some optimisation with disc space but got actually opossite from what I expected
>Difference is very small but still ...
>
>Is varchar introduced only for better compatibility with remote data or there is some other practical use to
>varchar fields versus old fashion character type columns ?
>
>TIA

Check this recent thread Re: Saving space with Varchar Thread #1345228 Message #1345231
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform