Q:

Do mysql setting Spanish equal English？

I run this command
select 'Conceição do Almeida'='Conceicao do Almeida';

The left side of the equal sign is Spanish,and the other side is English.
But,It return 1 as result!
Obviously, this is completely different two strings!
Do mysql setting  Spanish equal English？
By the way
character_set_client        utf8mb4
character_set_connection    utf8mb4
character_set_database      utf8
character_set_filesystem    binary
character_set_results       utf8mb4
character_set_server        utf8
character_set_system        utf8

So I don't think this about coding errors.

A:

The compare depends on the collation you use.
See this SQLFiddle example.
So either change your table collation or use a specific collation in your queries like utf8_bin.

