Good morning, this is my first topic, so thanks for all outcoming help.
I'm working in a Yii application with a MySQL database. This database has a countries table that has a column called name with a utf8_general_ci collation. This column is filled by data with special characters as Åland Islands
Using the Mysql regular sorting, the column name doesn't have a correct sorting behaviour, for example:
Correct:
Albania
Åland Islands
Actual:
Åland Islands
Albania
Referencing to ASCII table, 'Å' is 197 instead of 'A' is 65.
I tried to use many solutions from the Web (including REGEXP), without success.