MySQL - Differentiate between BINARY and VARBINARY in MySQL

Differentiate between BINARY and VARBINARY in MySQL.

BINARY and VARBINARY have the same nature of differences like CHAR and VARCHAR. Even though BINARY and VARBINARY are binary byte data types, they have differences when it comes to storage. BINARY stores values in fixed lengths while VARBINARY stores in variable depending on the type of values. Values in BINARY data type are padded with 0x00 which is not the case with VARBINARY.
MySQL - Differentiate between CHAR and VARCHAR in MySQL
Differentiate between CHAR and VARCHAR in MySQL - CHAR stores the data or values in fixed length format. If the size of the string is smaller than the specified length.......
MySQL - Differentiate between CHAR and NCHAR.
Differentiate between CHAR and NCHAR - CHAR is commonly referred to as character while NCHAR is referred to as NATIONAL CHARACTER......
MySQL - What are date and time data types supported in MySQL?
What are date and time data types supported in MySQL? - MySQL supports the following date and time data types......
Post your comment

Related Content

Follow us

▲