Chapter 4 SQL Data Types: CHAR & VARCHAR
Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!
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
