Difference between CHAR and VARCHAR in MySQL

Home > 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, 827👍, 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, 841👍, 0💬

Introduction to SQL Basics in MySQL
Where to find answers to frequently asked questions on Introduction to SQL Basics in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Introduction to SQL Basics in MySQL. Clear answers are provided with tutorial exercises on character and nu... 2018-04-21, 838👍, 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, 828👍, 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, 827👍, 0💬

Date and Time Data Types in MySQL
What Are Date and Time Data Types in MySQL? MySQL supports the following date and time data types: DATE - A date in the range of '1000-01-01' and '9999-12-31'. Default DATE format is "YYYY-MM-DD". DATETIME - A date with the time of day in the range of '1000-01-01 00:00:00' and '9999-12-31 23:59:59'.... 2018-01-19, 811👍, 0💬

Evaluating Expressions with SELECT Statements in MySQL
How To Calculate Expressions with SELECT Statements in MySQL? There is no special SQL statements to calculate expressions. But you can use the "SELECT expression FROM DUAL" statement return the calculated value of an expression. "DUAL" is a dummy table in the server. The tutorial exercise below show... 2018-04-12, 796👍, 0💬

Including Comments in SQL Statements in MySQL
How To Include Comments in SQL Statements in MySQL? If you want to include comments in a SQL statement, you can first enter "--", then enter your comment until the end of the line. The tutorial exercise below shows you some good examples: SELECT 'Hello world!' FROM DUAL; -- My first SQL statement! I... 2018-04-12, 756👍, 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, 739👍, 0💬

Groups of Data Types in MySQL
How Many Groups of Data Types in MySQL? MySQL support 3 groups of data types as listed below: String Data Types - CHAR, NCHAR, VARCHAR, NVARCHAR, BINARY, VARBINARY, TINYBLOB, TINYTEXT, BLOB, TEXT, MEDIUMBLOB, MEDIUMTEXT, LONGBLOB, LONGTEXT, ENUM, SET Numeric Data Types - BIT, TINYINT, BOOLEAN, SMALL... 2018-04-21, 737👍, 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.