This topic describes the conversion functions that are supported by PolarDB-X 1.0.

PolarDB-X 1.0 supports the following conversion functions.

Function Description
BINARY Cast a string to a binary string
CAST() Cast a value as a certain type
CONVERT() Cast a value as a certain type

The CONVERT() function supports only the CONVERT(expr USING transcoding_name) syntax. If you need to use CONVERT(expr,type), use CAST(expr AS type) instead.