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 everybody,

    i got a question concerning values inserted into the database after installing a modx-website locally and changing the database charset & collation...

    the Database on the live server used:
    Character Set and Collation (latin1, latin1_german2_ci)

    locally i imported it to:
    CHARACTER SET utf8 COLLATE utf8_general_ci

    everything works well, i just realised another value used for the database-table own_id, pictures uploaded on the live server got an 0, pictures uploaded got an "NULL", see here (green upload live server, red upload locally)
    www.kunane.com/modx/maxigallery/maxigallery_db.jpg

    the table looks like this (upload live site):
    www.kunane.com/modx/maxigallery/maxigallery_old.jpg

    upload locally:
    www.kunane.com/modx/maxigallery/maxigallery_new.jpg

    is this value the same, and either "0" or "NULL" depends on the Database Charset & Collation?

    i just want to make sure that i don’t run into any problems later, the site is in progress and the pictures are just dummy-content which will be deleted anyways...

    that’s my original post on the change of database charset:
    http://modxcms.com/forums/index.php/topic,36967.msg223094.html

    thanks, j
      • 7923
      • 4,213 Posts
      Doesn’t matter for MaxiGallery that is the field value 0 or null for the pictures that should not have web user ids.. was that your question?


        "He can have a lollipop any time he wants to. That's what it means to be a programmer."
        • 26931
        • 2,314 Posts
        Hi doze,

        thanks for your reply...yes basically that was my question smiley

        just being curious...could this (value either 0 or NULL) be connected to the different database character set?

        j
          • 28042 ☆ A M B ☆
          • 24,524 Posts
          No, it’s connected to the different database configurations for dealing with null input values.
            Studying MODX in the desert - http://sottwell.com
            Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
            Join the Slack Community - http://modx.org
            • 26931
            • 2,314 Posts
            thanks sottwell smiley