Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compress a Field
Message
From
24/10/2003 10:35:56
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
 
 
To
23/10/2003 16:50:48
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00841789
Message ID:
00842117
Views:
23
Hi Alison

There are lots of compression utilities you can use in VFP to zip or otherwise compress. Look up "VFP Compression" on google for lots of examples.

However, if you are using a TEXT field in a SQL Server database then you need to check whether your version is allocating space for TEXT fields in 2K blocks. If it is, you may not see much saving if your source size is <4K. Second, you can't store binary files in a TEXT field because certain character combinations will truncate your field and corrupt the contents. You'll have to use an IMAGE field for binary data.

If you are talking about dbf tables, you can safely compress data for a memo file and see the savings you hope for. Or you can place your dbfs in a Windows compressed folder and though it says they are occupying 200Mb on disk it may be only 50mb physical storage. You might also consider $100 for a larger drive...

HTH

Regards

JR
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us.
"
-- Shakespeare: Coriolanus, Act 1, scene 1
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform