If you want to list your posts and order them by title, that is as simple as:
But if you are using international characters and/or another alphabet the default database settings may mess things up for you.
In Sweden for example, the last the letters in the alphabet are Å, Ä, Ö. So accordingly, posts with titles starting with those letters should come last in an ascending list, but by default ‘Å’ and ‘Ä’ will be considered as ‘A’ and ‘Ö’ as ‘O’ .
But there’s an easy fix for this. Simply change the collation of the post_title column.
Execute the following SQL query. Remember to back up your database before, just to be safe!
ALTER TABLE wp_posts CHANGE post_title post_title TEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci;
This will give your post_title column a Swedish collation, so please change to your desired collation.