Windows XP SP2
Upon installation step 2, MySQL reported an error:
Specified key was too long; max key length is 1000 bytes
when creating the pml_patron table.
I did a little bit for web search, and it turned out that the problem is that my MySQL's default encoding is set to utf8. MySQL somehow hardcoded the vchar-to-byte conversion ratio to 3 for utf8. This essentially "blows" most of the keys on pml_* tables to a very big size.
Since our library contains books that are not in western languages, we do need the utf8 support. Is there any way to work around this problem?