We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 26931
    • 2,314 Posts
    Hi there,

    after the host updated the PHP version to 7.1/7.2 I was forced to update to Evolution 1.4.5, now I see, that under Info the DB Charset & Collation is set to latin1/latin1_german2_ci:


    even though MySQL is set to UTF8:


    and it only affects the first 3 rows of the database:


    the site is working and as far as I can see it doesn't affect it, but I'd like to know how that could happen and how I can get it all back to UTF8 - anyone got an idea?

    thanks a lot, cheers, j [ed. note: anonymized-26931 last edited this post 5 years, 5 months ago.]
    • Better way: go to backup in manager panel
      download sql file
      open in text redactor and by found and replace change all.

      but on 3 picture. i see what you set utf8_general_ci. and its not work (
      i think need write to hosting support.


      Or you can send Me access in mail [email protected] and i check .


      and best way for get help EVO write here:
      https://github.com/evolution-cms/evolution/issues

      it will be faster )
        http://modx.im - Russian community
        http://extras.evolution-cms.com - Repository for Evolution
        • 26931
        • 2,314 Posts
        Hi dmi3y,

        thanks for answering (I posted on GitHub as well https://github.com/evolution-cms/evolution/issues/845 )

        you mean download the current SQL file and just "find & replace" everything latin1_german2_ci to utf8_general_ci?

        upgraded another site and checked beforehand the collation and it also changed to latin1_german2_ci after for the first 3 rows

        for now I followed the instructions in the link posted on GitHub and it seems to work, but still wonder why it changed in the first place, never happened with any upgrade before)

        thanks (will send you E-Mail as well), cheers, j

        Quote from: dmi3y at Oct 29, 2018, 05:19 PM
        Better way: go to backup in manager panel
        download sql file
        open in text redactor and by found and replace change all.
        [ed. note: anonymized-26931 last edited this post 5 years, 4 months ago.]