How to sort databases alphabetically without accented characters being out of order

Question

I am creating a database in Mysql and want to put some information in alphabetical order. The problem is that when I add the ascending alphabetic order filter, words starting in accented characters appear last. For example: If I put the entries "Water", "Alarm" and "Sour', the order is "Alarm", "Sour" and "Water".

I want the alphabetical order to be maintained, regardless of whether or not the character is accentuated.