MySQL Table COLLATION utf8_turkish_ci To utf8_general_ci

Question

I have 2 tables and I want to join these tables. But one sorting table is utf8_turkish_ci, the other is utf8_general_ci. These tables are large (2.9GB / 550MB). Therefore, I do not want to use the COLLATION keyword in a query because it slows down in my query.

My question is: if I changed the COLLATION table from utf8_turkish_ci, did utf8_general_ci distort or change any character in the lines?

thanks

Answer 1

Changing the sort does not change the characters. Sorting is a rule (or rules) that tells how to compare characters.

From the documentation - A character set is a set of characters and encodings. Sorting is a set of rules for comparing characters in a character set.