Comment 5 for bug 1231920

Some updates on this. Robert's supplied patch changes the collation type of some columns to binary. We'd need to do this in on installation as well (which wouldn't be too hard, just toss it in the post-install function).

We were discussing at a meeting recently whether it might be a good idea to just set the default collation for the whole database, to binary. Apparently there is at least one of our clients who has done this with a production Mahara instance, and it has worked out fine for them as far as we know.

If we did decide to do that, we could make it be part of the installation sanity check. That way, people setting up new databases would be prompted to set the collation correctly, while people in existing Mahara databases would not find their site suddenly complaining about it.