[Mediawiki-l] Mediawiki Installation

[ekompute]

Hi, I am confused as to choosing which options:

   - InnoDB OR MyISAM
   - MySQL 4.1/5.0 binary OR MySQL 4.1/5.0 UTF-8 OR MySQL 4.0
   backwards-compatible UTF-8

I am hosting it in Hostgator, a public web installation. Mediawiki says in
the installation:

InnoDB is best for public web installations, since it has good concurrency
support. MyISAM may be faster in single-user installations. MyISAM databases
tend to get corrupted more often than InnoDB databases.
However, my previous webhost proposed MyISAM. Also Mediawiki says:

In *binary mode*, MediaWiki stores UTF-8 text to the database in binary
fields. This is more efficient than MySQL's UTF-8 mode, and allows you to
use the full range of Unicode characters. In *UTF-8 mode*, MySQL will know
what character set your data is in, and can present and convert it
appropriately, but it won't let you store characters above the Basic
Multilingual Plane<http://en.wikipedia.org/wiki/Mapping_of_Unicode_character_planes>.


but my previous webhost proposed MySQL 4.0 backwards-compatible UTF-8.

I plan to use InnoDB and MySQL 4.1/5.0 binary. Is this a wise decision?

Regards,

PM Poon