Is there any way for Eloquent to automatically add the COLLATE NOCASE to queries when the connection used is sqlite?
I'm having failures in my tests because I use slite in memory for testing and MySql for production and I noticed that sqlite is case sensitive by default for values comparisson.
I think this can be done using global scopes
https://laravel.com/docs/5.7/eloquent#query-scopes
If this is for testing only you will need to add a conditional to the scope
if (App::environment(testingl')) {
// apply collate no case scope
}
Please or to participate in this conversation.