set language for eloquent alphabetic orderBy

Question

I want to sort an alphabetical column and using the orderBy method in Laravel eloquent.

like below:

Post::where("some conditions")->orderBy('name','desc')->get();

I'm working with the Persian language and the result seems to use the Arabic alphabet.

I want to change this default alphabet only. can eloquent and MySql handle this at all?

user_175250 · Answer

Here's an answer in how you could accomplish this in MySQL:

Here's how to configure a default collation setting in Laravel:

Or you could use Laravel's raw system to add collation yourself on the specific query: