First page Back Continue Last page Image

In SQL you can have either CHAR or VARCHAR types for Character Data

What is the difference, or why use one over the other?

CHAR(2)

VARCHAR(20)

Fixed Field Size – You know how big the data for this field will always be

Variable Field Size – You Do Not know how big the data will be

Data Of Type: Character (A String Variable)