Über Google gefunden in den HostEurope-FAQ:

SELECT utf8_spalte FROM tabelle
ORDER BY CONVERT(utf8_spalte USING utf8)
COLLATE utf8_german2_ci ASC;