Sort order in views with non ASCII characters (å,ä,ö)

This support ticket is created 7 years, 9 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	-	14:00 – 20:00	14:00 – 20:00	14:00 – 20:00	14:00 – 20:00	14:00 – 20:00
-	-	-	-	-	-	-

Supporter timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Tagged: Custom search, Views, Views plugin

This topic contains 2 replies, has 2 voices.

Last updated by Simon 7 years, 9 months ago.

Assisted by: Beda.

Author

Posts

July 8, 2016 at 7:49 am #414417

Simon

I am trying to: Sort a view with the field "last name" in ascending order where the Swedish letters å, ä and ö should be listed last after z.

I visited this URL: hidden link

I expected to see: The field "last name" Åberg and Öberg last. The order in the Swedish alphabet is å, ä and ö after z.

Instead, I got: The last name Åberg first (interpreted as A?) and Öberg in the middle (interpreted as O after N?).

The database and it's tables is in utf8mb4_unicode_ci.

Best regards,
Simon

July 8, 2016 at 10:17 am #414455

Beda

I fear this is not a Views issue.

The Views Plugin uses the WP Query, it's just a GUI-Wrapper for that native WordPress Query.

Now, things you can try are converting your DataBase to utf8_swedish_ci, but I am not sure that will work.

I suggest performing a good DataBase backup first, or try on a Local Install.

July 8, 2016 at 11:55 am #414484

Simon

Thank you Beda,

I will try changing the collation on a test site.

Best regards,
Simon

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.