Helping doctrine to manage MySQL case sensitivity.

How MYSQL manage this:

How PHP manage it:

At this point, we have:

SELECT LOWER('JOSÉ.PEREZ@FAKEMAIL.COM')
# josé.perez@fakemail.com
strtolower('JOSÉ.PEREZ@FAKEMAIL.COM')
# josÉ.perez@fakemail.com

Our issue with that…

How to fix this ?

Why it should be fixed:

Performance issue with old version of MySQL:

--

--

--

Symfony lover, Gopher and opensource enthusiast. Ex-firefighter 🚒, I miss cuting out cars 🚙.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

🔨 Cool Contracts or Hypermedia Recipes?

How to Dockerize Spring boot Application + vueJs + postgresql

GORM Association (t+1) to 1 database query

Weeknotes S2 E1 2020

Inspecting UI Elements for WinAppDriver automation using Appium Desktop — Continued

Generate Random Data in Snowflake

“Too many soql 101 limitation” in salesforce

How to ssh into GCP using Windows Terminal

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Thomas P

Thomas P

Symfony lover, Gopher and opensource enthusiast. Ex-firefighter 🚒, I miss cuting out cars 🚙.

More from Medium

How to test Github Actions locally

Tests are important and here’s WHY!

How to build a CRUD App on Heroku with Php & Pdo & Github Deployment & ClearDB & MySQL Workbench

Building a “People who bought this item but also bought” recommendation engine.

Rough process flow of how the recommended products are generated.