MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.30


SELECT 'abc' = 'abc ', 'abc' = 'abc';


'abc' = 'abc '
'abc' = 'abc'


0
1


CREATE TABLE test ( name VARCHAR(25) charset 'UTF8' );

INSERT INTO test VALUES ('abc'), ('abc '), (' abc');

Records: 3  Duplicates: 0  Warnings: 0


SELECT name = 'abc ', name = 'abc', name, length(name) FROM test;


name = 'abc '
name = 'abc'
name
length(name)


1
1
abc
3

1
1
abc
4

0
0
 abc
4


CREATE TABLE test2 ( name VARCHAR(25) charset 'UTF8' );

INSERT INTO test2 VALUES ('abc'), ('abc '), (' abc');

Records: 3  Duplicates: 0  Warnings: 0


SELECT t1.*, t2.*, length(t1.name), length(t2.name)
  FROM test  AS t1
  JOIN test2 AS t2
    ON t1.name = t2.name
;


name
name
length(t1.name)
length(t2.name)


abc
abc
4
3

abc
abc
3
3

abc
abc
4
4

abc
abc
3
4

 abc
 abc
4
4


show create table test;


Table
Create Table


test
CREATE TABLE `test` (
  `name` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci