search

Kyslik / column-sortable

Package for handling column sorting in Laravel 5/6/7/8
MIT License
644 stars 105 forks source link

Not working for other language names #131

Closed msdavid1296 closed 5 years ago

msdavid1296 commented 5 years ago

Hi, In my columns, I have both English and Norwegian names. It did not give me the correct result.

https://en.wikipedia.org/wiki/Danish_and_Norwegian_alphabet

I want the results like the above link.

can this be done in the plugin?

Kyslik commented 5 years ago

Can you check https://github.com/Kyslik/column-sortable/issues/129?

msdavid1296 commented 5 years ago

No, I am not talking about the title. I have name column in the table,

The columns have both English and Norwegian names. And it is not getting sorted according to the Norwegian alphabet. Please refer the below link. https://en.wikipedia.org/wiki/Danish_and_Norwegian_alphabet

Kyslik commented 5 years ago

The sorting happens in your database; this package is abstraction and a helper tool for Eloquent which then constructs SQL query. Package does not support setting / overriding collation. Configure your table with correct collation and you should be good to go.

https://en.wikipedia.org/wiki/Collation

msdavid1296 commented 5 years ago

Oh Okay. Thanks for the info