Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Data Types in SQL

Your first table
Text data types
Summary

Instruction

As you can see, nothing unexpected happened – the row was added successfully. This is because the limit set for varchar defines the maximum number of characters, but it will accept anything shorter than that!

How about longer values? Let's find out.

Exercise

The longest last name in history is probably that of a German typesetter: 'Wolfeschlegelsteinhausenbergerdorff'. Someone on the website, named Adam, thought it would make a perfect nickname. Will the 35-character-long nickname work? Try to add Adam and his nickname to the table user_account.

Stuck? Here's a hint!

Type:

INSERT INTO user_account VALUES
('Adam', 'Wolfeschlegelsteinhausenbergerdorff');