Chapter 4 SQL Data Types: CHAR & VARCHAR

VARCHAR

lets you put in any number of characters up to the specified limit.

Which of these would likely NOT be stored using CHAR in SQL?

Names

Which of these would NOT likely be stored using VARCHAR in SQL?

Phone numbers (including area codes)

Which of these is a properly formatted CHAR example?

book_id CHAR(5)

Which of these is a properly formatted example of VARCHAR?

first_name VARCHAR(10)

CHAR

lets you put in a specific amount of characters into a record entry, with no exceptions made for more or fewer characters than the number specified for in the parentheses