In Part I of this tutorial, we uploaded the MODX files to the server. Now, it’s time to create the MODX Database. If you ran the MODX setup script at this point, it would attempt to create the database for you. On some servers this will work, but even if it does, on many servers (including Arvixe) you’d end up with a Latin1 character set and a collation or latin1_swedish_ci. For odd historical reasons, this is the MySQL default. It can work if your language is English and you never need a foreign word on your site, but sooner or later, you’re going to need to use a word with an accented character that doesn’t play well with Latin1.
The recommended character set and collation for MODX is utf-8 and utf8_general_ci, so I always set up the MODX database ahead of time on order to make sure that the database uses that character set. Learn More