MySQL Collation: Case Sensitive vs Case Insensitive
When I was a student, I created the database just give the name and leave the other option as default. I was assumed that the MySQL compare is case insensitive. Then, I learned that MySQL actually gives us the option to control how comparison works. This behavior is handled by a collation. By default, MySQL

