Thx Sergey

If a normal character field in a table has many spaces in it, will it take up as much disk space as a character with text in it? Is there any way around this ?

The character fields are only part full, is they any way to save space?


>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?