ORDER BY

[Anon]

I want MySQL to treat "Aa" in the start of a string as "Å", since Aa equals Å in my language.

Any suggestions of how to do this?

[tomhath]

This section from the manual might be what you are looking for:

4.6.3 Adding a New Character Set
To add another character set to MySQL, use the following procedure.

Decide if the set is simple or complex. If the character set does not need to use special string collating routines for sorting and does not need multi-byte character support, it is simple. If it needs either of those features, it is complex.
For example, latin1 and danish are simple character sets while big5 or czech are complex character sets.
...(instructions on how to add a character set)...