Overview of cast functions and operators

Name

Description

BINARY()

Function that converts values ​​to binary strings

CAST()

Convert values ​​to specific types for decimal values ​​and character types

CONVERT()

Convert value to a specific type for converting between date and time values ​​and decimals

DECODE()

Decode binary data into text representation

ENCODE()

Encode binary data into text representation