@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:
cole (should be before "espion" instead)

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


Included screenshot & HTML


@gaumondp commented on July 2nd 2013

Attachment: Screenshot of Keywords sorting

@gaumondp commented on July 2nd 2013

Attachment: HTML output of Keywords table containing accentuated "e"

@mattab commented on July 14th 2013 Member

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