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