On MySQL we need to translate:

• cast(string as String(10)) to cast(string as char(10))
• cast(string as Binary(10)) to cast(string as binary(10))