Hmmm...what's the difference between those two collations? A quick search through the code revealed that all the tables I made just specify the CHARACTER SET UTF8, which I guess uses the default collation. I think I made this decision because that's what Drupal does. I don't think we care which collation we use, so long as we're consistent.

I recommend we take out all of the COLLATE statements in our code.