Mysql does not sort swedish ÅÄÖ right

[vigour]

I just discovered a problem. Mysql does not sort swedish ÅÄÖ right. This is the result:

Bergvik
Marmaverken
Östersund
Söderhamn

The right sort order should be:

Bergvik
Marmaverken
Söderhamn
Östersund

This is my query:

$result = mysql_query("SELECT DISTINCT `place`.`place`, `place`.`place_id` FROM `products`, `place` WHERE `products`.`place_id` = `place`.`place_id` ORDER BY place");

Can someone please tell me what the problem is?

[vigour]

I changed from utf8-unicode_ci to utf8_swedish_ci. That seems to fix the problem.

vigour;10920657 wrote:

I just discovered a problem. Mysql does not sort swedish ÅÄÖ right. This is the result:

Bergvik
Marmaverken
Östersund
Söderhamn

The right sort order should be:

Bergvik
Marmaverken
Söderhamn
Östersund

This is my query:

$result = mysql_query("SELECT DISTINCT `place`.`place`, `place`.`place_id` FROM `products`, `place` WHERE `products`.`place_id` = `place`.`place_id` ORDER BY place");

Can someone please tell me what the problem is?