ceberlin Posted June 28, 2013 Share Posted June 28, 2013 I find unusal that the PW created database turns out to be a mix of MyISAM and InnoDB tables, Most collations are utf8_general_ci, but I fould also ascii_general_ci and _latin1_swedish_ci. Maybe this is coming from modules... I am not a database pro, I am designer, but to me this looks like potential trouble with searches, sortings and so on. Link to comment Share on other sites More sharing options...
ryan Posted June 29, 2013 Share Posted June 29, 2013 The only InnoDB table I'm aware of in ProcessWire comes from the DB session storage module, which is able to perform better with InnoDB than MyISAM. ProcessWire uses ascii_general_ci in some cases where the field can only ever support characters from the ASCII set, like "name" fields for instance. Everything else in ProcessWire uses utf8_general_ci. If you are seeing latin1_swedish_ci, chances are it came from an old version of ProcessWire or from a module that didn't specify collation. In some cases it matters, in others not. You may even want to change the collation in order to affect the way it sorts, for example. Ultimately I don't think you need to worry about it unless you have something that doesn't work properly or you want to change away from the default behavior of something. The defaults that we've chosen are what you want at least 99% of the time. 1 Link to comment Share on other sites More sharing options...
ceberlin Posted June 29, 2013 Author Share Posted June 29, 2013 Old modules from the past, I see. We have some problem here with the find() and I wanted to be sure to rule out some possibilities. Link to comment Share on other sites More sharing options...
ryan Posted July 3, 2013 Share Posted July 3, 2013 What is the problem you are seeing with find() ? 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