MySQL: Enforce UTF8 collation

[Nigel-catalyst]

Using a latin1 or other such collation is bad. Mahara takes all data as UTF8. If the database is using some other collation, things like MNET can break, and people can end up seeing "funny characters".

We should add an ensure_sanity() check. Though only for new installs somehow - we don't want to harass people running existing systems. Not sure of the best way to do this.

This bug was imported from eduforge.org, see:
https://eduforge.org/tracker/index.php?func=detail&aid=3286&group_id=176&atid=739

[Nigel-catalyst (nigel-catalyst)]

Also - it should be a case sensitive collation if at all possible. We expect this for postgres already, so it should be done in mysql too.

[Nigel-catalyst (nigel-catalyst)]

Done. Though we're not enforcing the case sensitiveness thing. May as well leave collations up to the user to decide.