How to add collate in laravel query

Question

In my project I am allowing user to search any thing. Recently facing an issue in Like query.

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation 'like'

I got a solution for this issue but now want to convert in laravel query.

How I can write user.name LIKE _latin1 '%aaa‬%' COLLATE latin1_swedish_ci this in ->where() of laravel

and my current query code is $query->where('user.name', 'LIKE', '%'.$search.'%');

score 1 · Answer 1 · answered Jun 25 '20 at 14:19

1

You can use whereRaw like this

$query->whereRaw("user.name LIKE _latin1 '%aaa‬%' COLLATE latin1_swedish_ci");

answered Jun 25 '20 at 14:19

sh1hab

Is there a way to use COLLATE inside where(). – Alfiza malek Jun 29 '20 at 11:40
@Rafikmalek you have to use `whereRaw` not just `where`. – sh1hab Jun 30 '20 at 07:50

1 Answers1