Laravel Eloquent is case sensitive

Question

I want to check if the inputted data already exists in the database. I've been trying to input data that already exists (but with different case) to test it. Here is my query

        $existing = AmenityType::all()
        ->where('type', $req->type)
        ->first();

but it doesn't return anything even if I did this

->where('lower(type)', strtolower($req->type))

The database collation is 'utf8mb4_unicode_ci'

Thank you.

0 experience with this language, but you could try replacing `'lower(type)'` with `lower('type')`. — Feathercrown, Mar 17 '17 at 12:22

Mihai Matei · Accepted Answer · 2017-03-17T09:47:10.023

1

Calling all() already returns you a Collection so the where clause is done on the collection instead on the db.

Try it like this:

$binds = array(strtolower($req->type));

$existing = AmenityType::whereRaw('lower(type) = ?'), $binds)->first();

var_dump($existing);

edited Mar 17 '17 at 09:47

answered Mar 17 '17 at 09:23

Mihai Matei

24,166
5
32
50

Thank you, but it says, "Method whereRaw does not exist." – jane doe Mar 17 '17 at 09:37
Now it should be work.. The problem is that you called `all()` method before the where clause – Mihai Matei Mar 17 '17 at 09:47
1

Oh! Thanks for pointing that out. It's working now! Thank you so much – jane doe Mar 17 '17 at 09:53

Laravel Eloquent is case sensitive

1 Answers1