Text

The Text data type is probably the most used data type in a database. Its properties are similar in nature to the Number data type, meaning it can have an input mask, validation rules, and a default value. The second, third, and fourth properties from the bottom of the list (IME Sentence Mode, IME Mode, Unicode Compression to be exact) all deal with translation properties when converting one database in one language to another, like from Japanese to English. These modes are beyond the scope of this manual.

Text fields can contain essentially every letter, character, and number. Text fields can also be set for a certain number of characters; 50 is the default size and 255 characters is the maximum size.

Memo

The Memo data type is very similar to the Text data type. The only real differences between the two are that a memo field can be much larger, up to 65,636 characters (roughly 35 pages of solid text!).