What does "ci" in "utf8_general_ci" stand for

Question

Short question:

What does the "ci" in "utf8_general_ci" mean / stand for?

Thanks

Answer 1

It means case insensitive. That way you don't have to worry about the case of letters in comparision for instance.

select 'A' = 'a' 

returns true for case insensitive databases.