mixed sql collation

[countrycharm]

While working out a kink in a previous topic here , in post #27 i(we) discovered that my sql db has a mixture of latin1 and utf8 collation.

A few questions:

• What are the consequences?
• Can it be fixed? If so what are the steps?

Always backup your database before installing any modules or doing anything to your database.

This PHP script can be used to convert your MySQL database tables from latin1-to-UTF8 while retaining the integrity of all internal multibyte characters.

http://www.zen-cart.com/downloads.php?do=file&id=1280