What is the difference between `CHAR(n)` and `VARCHAR(n)` data types?

Advanced SQL Developer Medium

Advanced SQL Developer — Medium

What is the difference between `CHAR(n)` and `VARCHAR(n)` data types?

Key points

  • CHAR pads to fixed length; VARCHAR stores actual characters
  • CHAR is faster for fixed-width data; VARCHAR saves space
  • CHAR always uses n characters; VARCHAR only uses necessary characters

Ready to go further?

Start full exam Practice more questions

Related questions