I don't think we will add an option to restore pre-5.6.27 behavior. The upstream considerations of how string literals are interpreted and that _binary needs to be prefixed apply to Percona Server the same. mysqldump indeed needs fixing, and let's keep this bug open for this (referring to http://bugs.mysql.com/bug.php?id=80150)
** Tags added: upstream ** Bug watch added: MySQL Bug System #80150 http://bugs.mysql.com/bug.php?id=80150 ** Summary changed: - "Invalid utf8 character string" warning with binary data + Restoring a dump of binary column, made with mysqldump, warns of invalid string ** Also affects: percona-server/5.5 Importance: Undecided Status: New ** Also affects: percona-server/5.6 Importance: Undecided Status: New ** Also affects: percona-server/5.7 Importance: Undecided Status: New ** Changed in: percona-server/5.5 Importance: Undecided => Medium ** Changed in: percona-server/5.6 Importance: Undecided => Medium ** Changed in: percona-server/5.7 Importance: Undecided => Medium ** Changed in: percona-server/5.5 Status: New => Triaged ** Changed in: percona-server/5.6 Status: New => Triaged ** Changed in: percona-server/5.7 Status: New => Triaged ** Also affects: mysql-server via http://bugs.mysql.com/bug.php?id=80150 Importance: Unknown Status: Unknown -- You received this bug notification because you are a member of Ubuntu Server/Client Support Team, which is subscribed to MySQL. Matching subscriptions: Ubuntu Server/Client Support Team https://bugs.launchpad.net/bugs/1623058 Title: Restoring a dump of binary column, made with mysqldump, warns of invalid string To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/1623058/+subscriptions -- Mailing list: https://launchpad.net/~enterprise-support Post to : enterprise-support@lists.launchpad.net Unsubscribe : https://launchpad.net/~enterprise-support More help : https://help.launchpad.net/ListHelp
