Alright! Now that you know a bit about text information, let's discuss the data types to represent them.
The basic data type for text information is
varchar data type always requires the length of the text which it's going to store. We put the length in brackets after the word
varchar. For instance, the following statement:
CREATE TABLE user_account (first_name varchar(32));
will create a table with a single column
first_name whose data type is
varchar(32). This means that any value in this column must be 32 characters long or shorter.
Please note that if you ever use Oracle as your database, the data type is called
varchar2 instead of