Sorting

  • Erik Lennartsson
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 week 5 hours ago #172100 by Erik Lennartsson
Sorting was created by Erik Lennartsson
Hi folks!
In spite of having handled the booking program for our association for more than a year, it was today I saw that sorting does not handle the characters åäö and ÅÄÖ. The characters are used in Scandinavian languages. ä and ö are used also in German. What happening is that å and ä is considered as an a . The letter Ö and ö is sorted with letter O.

Is there a way to force EB to using UTF8?

Best regards
Erik Lennartsson
 

Please Log in or Create an account to join the conversation.

More
1 week 1 hour ago #172101 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Sorting
Hi Erik

What sorting you are talking about? Could you please send me screen of the page which you need sorting so that I can understand the issue easier and find a solution?

Regards,

Tuan

Please Log in or Create an account to join the conversation.

  • Erik Lennartsson
  • Topic Author
  • Offline
  • New Member
  • New Member
More
6 days 20 hours ago #172103 by Erik Lennartsson
Replied by Erik Lennartsson on topic Sorting
Hi Tuan.
Sorry about that.
The sorting error occurs in the Registrants list in both Backend and Frontpage for logged in admins.
The same sorting error occurs in the Event list from Backend.

All the  best
Erik
Ystad - Sweden
Attachments:

Please Log in or Create an account to join the conversation.

More
6 days 19 hours ago #172106 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Sorting
Hi Erik

Please access to My Downloads menu item, download latest package of Events Booking, update it to your site

Then access to domain.com/administrator/index.php?optio...l.convert_to_utf8mb4

Replace domain.com/administrator by administrator URL of your site. That would convert the table to utf8mb4 encoding and should solve the issue

Tuan

Please Log in or Create an account to join the conversation.

  • Erik Lennartsson
  • Topic Author
  • Offline
  • New Member
  • New Member
More
6 days 10 hours ago #172113 by Erik Lennartsson
Replied by Erik Lennartsson on topic Sorting
Hi Tuan.
Thanks a bunch. The problem was the database which you pointed at.

All the best.
Erik

Please Log in or Create an account to join the conversation.

More
6 days 10 hours ago #172115 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Sorting
You're welcome

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc