different algorithm for ORDER BY?

[duff_beer]

Is there a way to force the sorting algorithm of an ORDER BY?

I'm not talking about ASC, DESC.

I actually get the data ordered almost as I want, but some special characters (ö, æ, ...) are not in the order I need.

I want those special chars ordered as they were not special chars,
i.e.:

abcd
abco
abcö
abcu

and not

abcd
abco
abcu
abcö

How can I force the charset I need to comply with during the sorting?

Thanks

[CompiledMonkey]

I don't know about doing it in SQL, but you could certainly do it in code.

[r937]

does this help? --

The Character Set Used for Data and Sorting
5.7.1.1 Using the German Character Set

[duff_beer]

does this help? --

The Character Set Used for Data and Sorting
5.7.1.1 Using the German Character Set

Many many thanks! That was exactly what I was looking for!

My search on the manual was too specific and didn't get any result, or too vague and received too many, unuseful, links.

Thanks.

@CompiledMonkey: of course that was not an option, I needed a fast, one-pass, unbuffered ordering... thanks for the comment, anyway.

[CompiledMonkey]

@CompiledMonkey: of course that was not an option, I needed a fast, one-pass, unbuffered ordering... thanks for the comment, anyway.

Using the proper sorting algorithm could have given you very fast speeds, probably not SQL like, but pretty fast.