Upgrading our DB software.Been fighting with table and view character sets for hours. This is going to be the death of me.

UTF-8 and you're all set 👍

@olback I guess that's what I was trying not to do, but may try it anyways to see if it ends up being the best route.

@olback Hmmm actually i think I was overcomplicating things and UTF8 looks like the way to go.

Worth mentioning...we are upgrading from MySQL 5.0 to 8.0

@BobbyTables

Then use utf8mb4 / utf8mb4_unicode_ci .

A Lot of trouble is / was fixed in InnoDB by enabling innodb_large_prefix.

You should check and upgrade to Barracuda file format consistently... This will save you a lot of trouble in the future.

Cheers.

@IntrusionCM Thanks! Greatly appreciate the advice.