A character field size is limited to 254 characters.
>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.
--sb--