How to make WordPress Database Case Insensitive

When I started to work with WordPress I didn’t know anything about how databases works or anything related to encoding and character set, but as I started into adventure myself on places like `pre_get_posts`, and the `WP_Query` filters such as `posts_join` and `posts_where`, I quickly found that understanding how the database works was a key…