haylau Posted May 18, 2021 Share Posted May 18, 2021 Hi We are having some unusual errors on one of our installations (imports from Ebay not creating orders correctly) I was advised by the app developer (involic) to have a look at some tables in the database (We are on Mariadb) Whilst there, I noticed that our tables are a mixture of types and collations (MyISAM / InnoDb (and various collations) So 1) Does this matter? 2) Should they all be the same? 3) If they should all be the same - what should they be and how would I go about making them all the same Link to comment Share on other sites More sharing options...
nickz Posted May 19, 2021 Share Posted May 19, 2021 could be. Just change them Link to comment Share on other sites More sharing options...
yaniv14 Posted May 19, 2021 Share Posted May 19, 2021 You should set all collation to utf8 in case you need to save unicode in those tables Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now