MySQL - Difference between CHAR and VARCHAR in MySQL

Home > MySQL

Difference between CHAR and VARCHAR in MySQL

Q

What Are the Differences between CHAR and VARCHAR in MySQL?

✍: FYIcenter.com

A

CHAR and VARCHAR are both ASCII character data types by default. But they have the following major differences:

CHAR stores values in fixed lengths. Values are padded with space characters to match the specified length.
VARCHAR stores values in variable lengths. Values are not padded with any characters. But 1 or 2 extra bytes are added to store the length of the data.

The table below shows you a good comparison of CHAR and VARCHAR data types:

Value    CHAR(4)       Length 
''       '    '        4 bytes
'ab'     'ab  '        4 bytes
'abcd'   'abcd'        4 bytes 

Value    VARCHAR(4)    Length
''       ''            1 byte 
'ab'     'ab'          3 bytes
'abcd'   'abcd'        5 bytes

⇒Introduction to SQL Basics in MySQL

⇒⇒MySQL Database Tutorials

2018-01-19, 700👍, 0💬

Character String Data Types in MySQL
What Are Character String Data Types in MySQL? MySQL supports the following string data types: CHAR(n) same as CHARACTER(n) - Fixed width and " " padded characters strings. Default character set is ASCII. NCHAR(n) same as NATIONAL CHARACTER(n) - Fixed width and " " padded character strings with UTF8... 2018-04-12, 711👍, 0💬

Difference between BINARY and VARBINARY in MySQL
What Are the Differences between BINARY and VARBINARY in MySQL? Both BINARY and VARBINARY are both binary byte data types. But they have the following major differences: BINARY stores values in fixed lengths. Values are padded with 0x00. VARBINARY stores values in variable lengths. Values are not pa... 2018-01-19, 711👍, 0💬

Difference between CHAR and VARCHAR in MySQL
What Are the Differences between CHAR and VARCHAR in MySQL? CHAR and VARCHAR are both ASCII character data types by default. But they have the following major differences: CHAR stores values in fixed lengths. Values are padded with space characters to match the specified length. VARCHAR stores value... 2018-01-19, 701👍, 0💬

Numeric Data Types in MySQL
What Are Numeric Data Types in MySQL? MySQL supports the following numeric data types: BIT(n) - An integer with n bits. BOOL same as BOOLEAN - Boolean values stored in 1 bit. TINYINT - A small integer stored in 1 byte. SMALLINT - A small integer stored in 2 bytes. MEDIUMINT - A medium integer stored... 2018-01-19, 620👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.