this is a dev issue, the scheme is setup by diaspora-common, I didn’t check who maintain the package if he/she comes to visit discourse but if you know, tell him/her
actually the fix partially solved the problem. French characters are broken now in the posts and profiles. I suspect there is a bug with character encoding generally… Has anyone else seen this error on non package install base ? I didn’t dig in the code yet, I am new to diaspora architecture, maybe there is a problem with the frontend… Nowadays it is best to use UTF-8 everywhere …
Once again: The debian package is unsupported. We are not able to provide support. Ask the maintainers of that package. If the collation is wrong on one table, it’s probably wrong on all tables. Changing the collation without manually converting the data is probably almost impossible, so good luck with that. A google search may help, I’m sure this is not a new issues. Otherwiese, the Debian maintainers can probably help you out, as they have to figure out a solution anyway, if that’s an issue in their default distribution.