What is the default length for a fixed-length text field?

• A. The length of a variable-length field; defaults to 512 characters.
• B. The length of a fixed-length text field; defaults to 255 characters.
• C. The maximum length is always 1,000 characters.
• D. The length is not fixed.

Answer: (B)

A fixed-length text field reserves a specific number of characters, and that size is set when the field is created. If you don’t specify a length, many systems use 255 characters as the default. This choice comes from historical conventions because 255 fits neatly in a single byte, offering a practical, widely-used default that balances typical short text needs with predictable storage. Because the field is fixed-length, space is allocated for the entire specified length regardless of how much text is actually stored, unlike variable-length fields that only use as much space as the content requires. So the default length you’ll see is 255 characters.