JSON encoding failed: Malformed UTF-8 characters, possibly incorrectly encoded

[OlafvdSpek]

JSON encoding failed: Malformed UTF-8 characters, possibly incorrectly encoded after setting display transformation to Binary to IP for a varbinary column and browsing that table.

5.0.0-rc1

[Tithugues]

Would it be possible to have a structure and a set of data to reproduce it please?

[goblin2oo8]

I have same bug. Column type binary(16)
Data example INSERT INTO test_table SET ip = INET6_ATON('::ffff:8.8.8.8')
If I use function INET6_NTOA in SELECT query - it is works
But display transformation not working, error write:
JSON encoding failed: Malformed UTF-8 characters, possibly incorrectly encoded

[williamdes]

@harsh-kukreja @Gaurav-Punjabi @victorphoenix3 @kartik1000 first one who wants to work on it (if it can be reproduced) comments here :)

Affects 5.0 ?

[kartik1000]

Well I'll first try to reproduce @williamdes and then let you know 😄

[williamdes]

CREATE TABLE `aes` (
  `id` int(11) NOT NULL,
  `charreg` varchar(255) NOT NULL,
  `charbin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `vbin` varbinary(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `aes` (`id`, `charreg`, `charbin`, `vbin`) VALUES
(1, 'ded', 'ded', 0x0ded),
(2, 'ded', 'ded', 0x0ded),
(3, 'fef', 'fef', 0x0fef),
(4, '0x7f000001', '0x7f000001', 0x30783766303030303031);