CALCITE-111, we now support CONVERT(charValue, srcCharsetName, destCharsetName) that works on converting character sets.
CONVERT(charValue USING transcodingName) also fits the SQL standard, and MySQL has implement it, which is the same as TRANSLATE(charValue USING transcodingName)
- select convert('employ_id' using utf16) as alia from employee
- select translate('employ_id' using utf8) as alia from employee
Noted: Calcite already supports this from the parser.