How mysql converts data to binary

Today, I would like to share with you the relevant knowledge points about how mysql converts data into binary. The content is detailed and the logic is clear. I believe most people still know too much about this knowledge, so share this article for your reference. I hope you can get something after reading this article. Let's take a look.

Conversion methods: 1, the use of BIN () function, syntax "SELECT BIN (number)"; 2, the use of BINARY () function, syntax "SELECT BINARY" value ""; 3, the use of CAST () function, syntax "SELECT CAST (value AS BINARY)".

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

Mysql converts data to binary

Method 1: using the BIN () function

The BIN () function returns the binary representation of a number as a string value.

Syntax:

SELECT BIN (number)

Example: returns a binary representation of 111

SELECT BIN (111)

Method 2: using the BINARY () function

The BINARY function converts a value to a binary string.

Syntax:

SELECT BINARY "data value"

Method 3: using the CAST () function

The CAST () function converts (any type) value to the specified data type.

CAST (value AS BINARY) has the same function as the BINARY () function, which converts a value to a binary string.

BINARY: converting value to BINARY (binary string)

These are all the contents of the article "how mysql converts data to binary". Thank you for reading! I believe you will gain a lot after reading this article. The editor will update different knowledge for you every day. If you want to learn more knowledge, please pay attention to the industry information channel.