search

richjoslin / rivety

An extension of the Zend Framework for easily building websites with logins, permissions and roles, CMS, etc. [WARNING: ABANDONED]
Other
2 stars 1 forks source link

change all db tables and text fields to utf8_general_ci collation #19

Open richjoslin opened 12 years ago

richjoslin commented 12 years ago

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 commented 12 years ago

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 commented 12 years ago

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

richjoslin commented 12 years ago

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. ?