A mysql question

[m.roth2006 at rcn.com]

Anyone here have any idea how to set a system default for mysql? I'm trying to run confluence's full import, and I assume it just drops the d/b, rather than dropping its d/b table by table, and the system default when it recreates the d/b is a case-insensitive collation; meanwhile, in their docs, they're telling me to use case sensitive collation (and then they contradict themselves, but that's another story).

I set the collation, committed it, then ran the import (actually, it's rerunning it), and while that's running, I logged into mysql... and it's reset to case insensitive. I've grepped the backup that it's restoring from, and see no references to collation, so I assume it's a mysql default....

    mark