INFORMATION_SCHEMA.ROUTINES.ROUTINE_DEFINITION does not handle binary literals well

Description

  • I run a terminal using koi8-r character set.
    In case of gnome-terminal, do "Terminal >Set Character Encoding>Cyrillic(KOI8-R)

  • Start mysql like this:

  • And create a stored function returning a binary string

This SQL script returns:

Note, if I now run a new terminal using utf8 as a character set and run this query:

it returns

The expected result would be to replace the literal to X'HHHH' notation.

Environment

None

Status

Assignee

Alexander Barkov

Reporter

Alexander Barkov

Labels

None

External issue ID

None

External issue ID

None

Affects versions

Priority

Major
Configure