>i have a long text . which is better memo or character of table.
>thanks
That depends on your exact needs, but in general, memo is better for long texts, especially if the maximum length is variable. Character fields are limited to 255 characters. And memo use a variable size, which makes them more efficient for variable-length texts. For instance, if one of your texts is 50 bytes, and another, 200 bytes, you will use 50+4 bytes for the first (50 in the FPT, 4 in the DBF), and 200+4 for the second. (Depending on the setting of SET BLOCKSIZE, you may use some more space.) However, records that don't have ANY data in the memo field will also use 4 bytes in the DBF.
Mainly, you will have almost no size restriction, for your fields. You will be able to store data with much more than 255 bytes.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
