UTF8
This section contains reference documentation for UTF8 encode/decode functions.
fromUtf8returns UTF8 encoded string of input binary data (bytestype).toUtf8returns binary data (represented as a Hex string) from a UTF8 encoded string.
fromUtf8(bytesCol)toUtf8(string)
SELECT bytesCol1, fromUtf8(bytesCol1) AS utf8Str
FROM testTable
LIMIT 1
bytesCol1 | utf8Str |
|---|---|
68656c6c6f21 | hello! |
SELECT toUtf8('hello!') AS binaryOutput
FROM ignoreMe
binaryOutput |
|---|
68656c6c6f21 |
Last modified 1yr ago