What collations for UCS distinguishing accented characters from their unaccented equivalents are available?

Hi, an international site has some content in several latin languages, for example English and French. Sometimes 2 pages, one in English and one in French, have the same name except for an accent (for example, in English, Demonstration, in French, Démonstration). The site's database schema

Question on encoding parameters and binary fields encoding (character_set_connection)

Hi, I'm finding the description of character_set_connection unclear. Does this influence the encoding of queries, but not of results? I'm wondering about the effect of connection encoding. Is there documentation on how exactly character set settings affect BLOBs? For example, this is what