change all db tables and text fields to utf8_general_ci collation

[richjoslin]

I didn't think it would matter, but now it does. Certain MySQL string functions don't like when a field has one collation and a table has another. Changing them all to the same thing should prevent further issues.

[jaybill]

There should also be some kind of note in the instructions that you should
create the db like this:

CREATE DATABASE rivety CHARACTER SET utf8 COLLATE utf8_general_ci;

[jaybill]

Also, I like to listen to the radio at a reasonable volume while I'm
collating in utf8.

[richjoslin]

There could also be a command-line script that creates the database, downloads and extracts the tarball, sets proper permissions on certain directories, and copies and renames template files? It prompts you for directory names, database name, passwords, etc when needed. ?