Collation has nothing with the display to do. Only the character set has. Collation has with sorting to do primarily.
you should use latin1 or utf8 charset .. and a French collation collation if such exists if you want sorting done according to the rules of French language!