@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

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

@halfdan commented on September 9th 2013

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