The easiest solution is to make sure your database is defaulted to latin1 as the character set for any new tables. To find out what the current default is run this SQL code:
- Code: Select all
SHOW CREATE DATABASE databasename
If the encoding shows up as utf8, run the following SQL code on the same table:
- Code: Select all
ALTER DATABASE databasename DEFAULT CHARACTER SET latin1
Then run the phplist initialize. If you had run it and it failed, make sure you delete the tables before initializing again.
If you want to change the default encoding back to utf8 for future tables, run this code:
- Code: Select all
ALTER DATABASE databasename DEFAULT CHARACTER SET utf8