SET @@session.character_set_connection = 'latin1';
SELECT bin(inet_aton('10.0.0.1')) UNION DISTINCT SELECT bin(inet_aton('127.0.0.1'));

SET @@session.character_set_connection = 'utf8mb4';
SELECT bin(inet_aton('10.0.0.1')) UNION DISTINCT SELECT bin(inet_aton('127.0.0.1'));