Wordpress get_pages按post_title排序，包含非拉丁字符

Question

I use the following code to output Wordpress pages ordered by page title.

$args = array(
    'sort_order' => 'asc',
    'sort_column' => 'post_title',
    'hierarchical' => 1,
    'child_of' => $page,
    'parent' => -1,
    'post_type' => 'page',
    'post_status' => 'publish'
);

$pages = get_pages($args);

It works fine except for pages starting with non-latin characters. Å gets sorted as A, it should be in the end, following our Swedish alphabet.

Answer 1

It seems that the regular utf8_general_ci does not solve this issue with Swedish letters. This SQL command solved the issues.

alter table wp_posts convert to character set utf8 collate utf8_swedish_ci;