Level 48
Both of these should work with raw sql.
ORDER BY column COLLATE NOCASE
ORDER BY LOWER(column)
I'm not sure if you can do this with Eloquent but you should be able to use DB::raw() with the query builder.
2 likes
Apr 9, 2016
2
Level 9
sqlite problem -(case sensitive)
I am using sqlite as db. But It seems it is case sensitive when i sort the db tables. How can I fix this ? I couldn't find anything that works with laravel.
thanks
Level 56
There is the orderByRaw(...) method
[ https://github.com/laravel/framework/blob/5.2/src/Illuminate/Database/Query/Builder.php#L1269-L1280 ]
// using an eloquent model
$users = User::orderByRaw('name COLLATE NOCASE')->get();
// using the query builder
$users = \DB::table('users')->orderByRaw('name COLLATE NOCASE')->get();
1 like
Please or to participate in this conversation.