Mixed DB collations: should they all match
I've noticed a sprinkling of various table types and collations
Since the DB is an upgrade from 154, I can't say if the sprinkling occured before or after the DB update.
I don't want to continue with the upgrade process if these mix-match are going to cause greater headache in the future.
All but 1 table is MyISAM. sessions is InnoDB
Here's the list that I have right now that are not utf8_general_ci
admin_notifications: utf8mb4_general_ci
box_news: latin1_swedish_ci
box_news_content: latin_swedish_ci
dbio_reports: latin1_swedish_ci
dbio_reports_description: latin1_swedish_ci
dbio_stats: latin1_swedish_ci
ezpages_content: utf8mb4_general_ci
ip2country: latin1_swedish_ci
sessions: InnoDB: utf8mb4_general_ci
square_payments: latin1_swedish_ci
Rick
RixStix (dot) com
aka: ChainWeavers (dot) com
Bookmarks