Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving space with Varchar
Message
From
05/09/2008 14:44:50
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01345228
Message ID:
01345238
Views:
16
>
>The character fields are only part full, is they any way to save space?
>
Do you have real problems with disk space? Generally speaking, if your database is structured properly then half-empty character fields should be the least concern. Maybe you can split this field on two or more and/or use related table, but I would not recommend using memo just because you want to save space. Memo is used when you want to keep more than 255 characters.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform