ORDER BY with accents

When I sort texts with accents the accents end up in the end instead of near
the same text without accent.

For example, the 3 composers Händel, Haydn and Holst will appear in the
order Haydn, Holst, Händel.

Is it possible to instruct MySql to ignore the accents so that Händel comes
in first instead of last?

Thanks in advance,
Wim

> When I sort texts with accents the accents end up in the end instead of near[color=blue]
> the same text without accent.
>
> For example, the 3 composers Händel, Haydn and Holst will appear in the
> order Haydn, Holst, Händel.[/color]

You'll want to review the MySQL manual at
http://www.mysql.com/documentation/m...l#Localisation

Take a particular look at the German character set section.

http://www.mysql.com/documentation/m..._character_set

Lukas

> When I sort texts with accents the accents end up in the end instead of near[color=blue]
> the same text without accent.
>
> For example, the 3 composers Händel, Haydn and Holst will appear in the
> order Haydn, Holst, Händel.[/color]

You'll want to review the MySQL manual at
http://www.mysql.com/documentation/m...l#Localisation

Take a particular look at the German character set section.

http://www.mysql.com/documentation/m..._character_set

Lukas

> When I sort texts with accents the accents end up in the end instead
of near[color=blue]
> the same text without accent.
>
> For example, the 3 composers Händel, Haydn and Holst will appear in the
> order Haydn, Holst, Händel.[/color]

You'll want to review the MySQL manual at
http://www.mysql.com/documentation/m...l#Localisation

Take a particular look at the German character set section.

http://www.mysql.com/documentation/m..._character_set

Lukas

> When I sort texts with accents the accents end up in the end instead
of near[color=blue]
> the same text without accent.
>
> For example, the 3 composers Händel, Haydn and Holst will appear in the
> order Haydn, Holst, Händel.[/color]

You'll want to review the MySQL manual at
http://www.mysql.com/documentation/m...l#Localisation

Take a particular look at the German character set section.

http://www.mysql.com/documentation/m..._character_set

Lukas

ORDER BY with accents

re: ORDER BY with accents

re: ORDER BY with accents

re: ORDER BY with accents

re: ORDER BY with accents

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about