Keyword

sorting items in K2

  • Miroslav Ernst
  • Miroslav Ernst's Avatar Topic Author
  • Offline
  • Junior Member
More
7 years 3 months ago #159549 by Miroslav Ernst
sorting items in K2 was created by Miroslav Ernst
K2 ranks item (if entered in alphabetical order) wrong according to the Czech characters.

"Č" and "C" is taken as a single letter and the ranks so that "Č" is situated between the "C" as the next character, and not because it is "Č" was behind all the "C". see the need www.diochi.9e.cz/index.php?option=com_k2...y&id=149&Itemid=1007
You do not know what to do?

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 3 months ago #159566 by Krikor Boghossian
Replied by Krikor Boghossian on topic sorting items in K2
Hello K2 uses mySQL's alphabetical ordering.
stackoverflow.com/questions/10446787/how-can-i-control-utf-8-ordering-in-mysql

The collation should be entered manually in the view. However this would be considered a hack and I would advise you to proceed with caution.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • Miroslav Ernst
  • Miroslav Ernst's Avatar Topic Author
  • Offline
  • Junior Member
More
7 years 3 months ago #159590 by Miroslav Ernst
Replied by Miroslav Ernst on topic sorting items in K2
I'm sorry, but I did not understand it.
The link points to the sorting tables, but I do so I need to sort the items in K2

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 3 months ago #159618 by Krikor Boghossian
Replied by Krikor Boghossian on topic sorting items in K2
The link I set you is for sorting the results according to specific collations.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • Miroslav Ernst
  • Miroslav Ernst's Avatar Topic Author
  • Offline
  • Junior Member
More
7 years 3 months ago - 7 years 3 months ago #159627 by Miroslav Ernst
Replied by Miroslav Ernst on topic sorting items in K2
I found the solution. just change in database the comparison in table #_k2_items in column title from utf8_general_ci to utf8_czech_ci
Last edit: 7 years 3 months ago by Miroslav Ernst.

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


Powered by Kunena Forum