Skip to main content
List Manager logo
List Manager Forum

Sorting foreign characters in auto-filter select

User bonnielass

My list is in Swedish and we have the characters ÅÄÖ. In auto-filter select list the characters are ordered as AAO. How can I make the list order correctly according to Swedish standard?

Moonsoft support

Hi,
can you please specify which type did you use for that column/field? Is a free text field where users type or any other type like sql or manual list configured by you? We'll reproduce here and let you know how to fix.

Thanks, regards

User bonnielass

The select list in the filter module is generated from a type text field. Thanks!

User bonnielass

I also have a filter field type number that sorts incorrectly. I have numbers 1-14 and the select list sorts 1, 10,11,12,13,14,2,3,4. Do I need to add leading zero to all one digit values or can I make it work another way?

Moonsoft support

Hi,

We made some tests and seems to be working. Can you please place a private ticket at Helpdesk sharing a url and administrator credentials?

Thanks. Regards,

User bonnielass

Thanks for your trouble. However I solved the issue. I changed the collate on the field value in #__listmanager_values to utf8_swedish_ci and that did the trick.

Moonsoft support

Hi,
perfect, great it worked. Thank you very much for sharing!
Regards

...
CalcBuilder

Create dynamic calculators

Buy now!
...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!