mixed sql collation

**plc613** · 23 Apr 2014, 02:18 PM

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?

**countrycharm** · 24 Apr 2014, 01:19 AM

Originally Posted by plc613

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

**plc613** · 24 Apr 2014, 01:35 AM

Well that worked remarkably well. Thank you!

So I ran the script on my dev site and everything *appears* okay. What would be the true proverbial acid test to know for certain nothing is broken?

**countrycharm** · 24 Apr 2014, 04:50 AM

Originally Posted by plc613

Well that worked remarkably well. Thank you!

So I ran the script on my dev site and everything *appears* okay. What would be the true proverbial acid test to know for certain nothing is broken?

Go over all your site checking the links, looking at your product descriptions making sure you don't see any funny looking characters anywhere on your site.

**plc613** · 24 Apr 2014, 02:26 PM

Originally Posted by countrycharm

Go over all your site checking the links, looking at your product descriptions making sure you don't see any funny looking characters anywhere on your site.

So far, I've found this:

Zones Name:
K?rnten (KN)

Country: Austria

In the backend. However, in checking my live site I can confirm that this existed prior to the conversion. No oddities yet in the storefront.