Alphabet sorting does not work properly with unique characters I've a view with sorting by first character and it does not work properly for unique characters (f.x. danish characters: ø å æ).

What should I do in order to sort they properly?

Thanks.
I ended up with writing my own module. It uses hook views_query_alter and change SQL query little bit. Module does not have any settings in UI but hardcoded variables so you need to adjust it in order to solve issue with sorting.

&lt;?php

/**
 * @file
 * Implements hook_views_query_alter().
 *
 * it adds 'COLLATE utf8_language_ci' to languages that are not supported by default
 * so far there are only few languages we have issues with.
 */
function views_collate_sorting_views_query_alter(&amp;$view, &amp;$query) {
  // views where we want to enable collation
  $views = array(
    'dictionary_overview'
  );

  // exit if the current view is not specified
  if (!in_array ($view-&gt;name, $views)) {
    return FALSE;
  }

  // define list of languages we support
  $map = array(
    'da' =&gt; 'utf8_danish_ci',
    'sv' =&gt; 'utf8_swedish_ci',
    'nb' =&gt; 'utf8_danish_ci',
    'es' =&gt; 'utf8_spanish_ci',
    'pl' =&gt; 'utf8_polish_ci',
  );

  // get current utf8
  $l = $GLOBALS['language']-&gt;language;

  if (!array_key_exists ($l, $map)) {
    return FALSE;
  }

  // get current utf8 language which we are going to add to all sort fields
  $utf8 = $map[$l];

  // add COLLATE utf8_xx_ci to all sort criteria
  $orderby = &amp;$query-&gt;orderby;
  foreach ($orderby as &amp;$order) {
    $order['field'] .= ' COLLATE ' . $utf8;
  }
}