{"action":"created","issue":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/11609","repository_url":"https://api.github.com/repos/joomla/joomla-cms","labels_url":"https://api.github.com/repos/joomla/joomla-cms/issues/11609/labels{/name}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/11609/comments","events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/11609/events","html_url":"https://github.com/joomla/joomla-cms/issues/11609","id":171116216,"number":11609,"title":"Alphabetical ordering article title with extended character set","user":{"login":"ot2sen","id":790445,"avatar_url":"https://avatars.githubusercontent.com/u/790445?v=3","gravatar_id":"","url":"https://api.github.com/users/ot2sen","html_url":"https://github.com/ot2sen","followers_url":"https://api.github.com/users/ot2sen/followers","following_url":"https://api.github.com/users/ot2sen/following{/other_user}","gists_url":"https://api.github.com/users/ot2sen/gists{/gist_id}","starred_url":"https://api.github.com/users/ot2sen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ot2sen/subscriptions","organizations_url":"https://api.github.com/users/ot2sen/orgs","repos_url":"https://api.github.com/users/ot2sen/repos","events_url":"https://api.github.com/users/ot2sen/events{/privacy}","received_events_url":"https://api.github.com/users/ot2sen/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/joomla/joomla-cms/labels/No%20Code%20Attached%20Yet","name":"No Code Attached Yet","color":"ededed"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":20,"created_at":"2016-08-15T06:37:33Z","updated_at":"2016-08-16T08:08:48Z","closed_at":null,"body":"A user asked how they could sort a category list correctly, when using Danish character set that has æ+ø+å as the last 3 letters extending the English a-z alphabet.\r\n\r\nThey had article with title starting with 'Ø' to show before 'P', as were it an 'O'. In Danish 'Ø' is the second last letter of the alphabet.\r\n\r\nI am uncertain whether this is to be handled in the localise.php of the individual language packs, or if it is an i18n issue in j 3.6.2.\r\n\r\nCould reproduce the issue using any of the Nordic languages, and could see this also was an issue when sorting search results alphabetically.\r\n\r\n#### Steps to reproduce the issue\r\n\r\n1. Set Danish (or norwegian or swedish) as default language.\r\n2. Create a series of articles in their own category with starting letters having a-z and also some having æ, ø and å.\r\n3. Create a menu item of the type 'Category list' with setting 'Title sort alphabetically' for articles.\r\n\r\n#### Expected result\r\n\r\nArticles were expected to be listed in the alpha order of the chosen language\r\n\r\n#### Actual result\r\n\r\nFor the tested languages, special letters æ and å listed after a, and ø listed after n, as are they considered to be a and o. \r\n\r\nAlso the search results show same pattern when selecting alphabetical ordering of results.\r\n\r\n#### System information (as much as possible)\r\n\r\nJoomla 3.6.2, non-English language packs with extra letters beyond a-z\r\n\r\n#### Additional comments\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/comments/240032291","html_url":"https://github.com/joomla/joomla-cms/issues/11609#issuecomment-240032291","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/11609","id":240032291,"user":{"login":"ralain","id":3478897,"avatar_url":"https://avatars.githubusercontent.com/u/3478897?v=3","gravatar_id":"","url":"https://api.github.com/users/ralain","html_url":"https://github.com/ralain","followers_url":"https://api.github.com/users/ralain/followers","following_url":"https://api.github.com/users/ralain/following{/other_user}","gists_url":"https://api.github.com/users/ralain/gists{/gist_id}","starred_url":"https://api.github.com/users/ralain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ralain/subscriptions","organizations_url":"https://api.github.com/users/ralain/orgs","repos_url":"https://api.github.com/users/ralain/repos","events_url":"https://api.github.com/users/ralain/events{/privacy}","received_events_url":"https://api.github.com/users/ralain/received_events","type":"User","site_admin":false},"created_at":"2016-08-16T08:08:48Z","updated_at":"2016-08-16T08:08:48Z","body":"It is theoretically possible to override the default collation directly in the SQL statement:\r\n\r\nSELECT title FROM table ORDER BY title COLLATE utfmb4_danish_ci;"}}
{"actor":{"display_login":"ralain"}}