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

Good job! Now, let's experiment a bit.

We told you that char(10) always takes 10 characters. This is unlike varchar(10), which can store 10 characters or less. Let's see what happens if we provide a shorter value to a char type.

Exercise

Peter wants to know what happens when a new user doesn't comply with the rule about 10-character-long nicknames. Try to add a new user, Adrian, whose nickname is soap27.