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

  • 2
    UTF-8 and you're all set 👍
  • 1
    @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.
  • 3
    @olback Hmmm actually i think I was overcomplicating things and UTF8 looks like the way to go.
  • 0
    Worth mentioning...we are upgrading from MySQL 5.0 to 8.0
  • 1

    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.

  • 0
    @IntrusionCM Thanks! Greatly appreciate the advice.
Your Job Suck?
Get a Better Job
Add Comment