@gaumondp opened this Issue on July 2nd 2013

When going in Referers->Search Engines and Keyword, sorting by keywords put accentuated words at the end. Same for "Page names" in Action->Page Titles.

Example for Keywords:
avion
espion
zoo
cole (should be before "espion" instead)

The URL to generate such list and see accentuated words first is:

index.php?module=CoreHome&action=index&idSite=5&period=range&date=last7#module=Referers&action=getSearchEnginesAndKeywords&idSite=5&period=range&date=last7

Included screenshot & HTML

Dali

@gaumondp commented on July 2nd 2013

Attachment: Screenshot of Keywords sorting
SortingAccents.png

@gaumondp commented on July 2nd 2013

Attachment: HTML output of Keywords table containing accentuated "e"
SortingAccents.html

@mattab commented on July 14th 2013 Owner

Thanks for the report, it looks like we could use the function http://nz1.php.net/strcoll

@halfdan commented on September 9th 2013 Member

Actually this should come sorted from the database.

@dalidev: What is the character set / collation of your database?

@gaumondp commented on September 9th 2013

UTF-8 wall to wall:

mysql> SHOW VARIABLES LIKE 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

Powered by GitHub Issue Mirror