The Difference between a Field Type of String and Text

Issue

You want to know the difference between a field with the type of string and text area.

Solution

Both a string and text field will hold information that you can freely write in. The major difference between the two fields is how many characters you can put in these fields. A string field has a limit of 255 characters, whereas a text field has a character limit of 30,000 characters. (This is a general rule.  It may vary by application and platform.)

• A string field is a good choice if you wanting to store data like address, names, or simple custom data.
• A text area field is a good choice when you want to store information from something like a comment box on a form or if you are importing a large block of text.