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.