Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving space with Varchar
Message
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:
01345240
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.

And with memo comes bloat and memo file corruption.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform