Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-53642

Support MySQL Databases using utf8mb4

XMLWordPrintable

    • 100
    • 2
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      As a confluence Administrator, when I set up a new instance of confluence 6.4 with MySQL using the utf8mb4 character set, the installer will refuse to continue with the datasource. This should be reverted to the behavior from 6.3 where it's possible to use this encoding for a new install.I can live with the somewhat nonsensical warning about unsupported character set / collation. 

      Currently, I would need to first install version 6.3, go through the Setup Assistant, then upgrade to 6.4. 

      INFO: UTF8MB4 is now supported in confluence 7.3.1. Please see the notes to migrate from UTF8 to UTF8MB4 here.
      If you are unable to migrate to UFT8MB4 please read  CONFSERVER-18509 - Confluence should handle this gracefully for most scenarios where 4-byte characters are used by providing meaningful error messages. 

            [CONFSERVER-53642] Support MySQL Databases using utf8mb4

            Sen Geronimo made changes -
            Workflow Original: JAC Suggestion Workflow 4 [ 3580065 ] New: JAC Suggestion Workflow 3 [ 4323009 ]
            Matthew Saxby (Inactive) made changes -
            Description Original: As a confluence Administrator, when I set up a new instance of confluence 6.4 with MySQL using the utf8mb4 character set, the installer will refuse to continue with the datasource. This should be reverted to the behavior from 6.3 where it's possible to use this encoding for a new install.I can live with the somewhat nonsensical warning about unsupported character set / collation. 

            Currently, I would need to first install version 6.3, go through the Setup Assistant, then upgrade to 6.4. 

            {panel:bgColor=#e7f4fa}
            *INFO:* UTF8MB4 is now supported in confluence 7.3.1. Please see the notes to migrate from UTF8 to UTF8MB4 [here|https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html].
            Please follow !https://jira.atlassian.com/secure/viewavatar?size=xsmall&avatarId=51493&avatarType=issuetype! CONFSERVER-18509 - MySQL databases incapable of handling 4byte UTF-8 Characters. Confluence should handle this gracefully for instances still staying on UTF8 with MySQL and interested in seeing meaningful error when 4byte character is used in these instances.
            {panel}             		New: As a confluence Administrator, when I set up a new instance of confluence 6.4 with MySQL using the utf8mb4 character set, the installer will refuse to continue with the datasource. This should be reverted to the behavior from 6.3 where it's possible to use this encoding for a new install.I can live with the somewhat nonsensical warning about unsupported character set / collation. 

            Currently, I would need to first install version 6.3, go through the Setup Assistant, then upgrade to 6.4. 
            {panel:bgColor=#e7f4fa}
            *INFO:* UTF8MB4 is now supported in confluence 7.3.1. Please see the notes to migrate from UTF8 to UTF8MB4 [here|https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html].
            If you are unable to migrate to UFT8MB4 please read  !https://jira.atlassian.com/secure/viewavatar?size=xsmall&avatarId=51493&avatarType=issuetype! CONFSERVER-18509 - Confluence should handle this gracefully for most scenarios where 4-byte characters are used by providing meaningful error messages. 
            {panel}
            Ganesh Gautam made changes -
            Description Original: As a confluence Administrator, when I set up a new instance of confluence 6.4 with MySQL using the utf8mb4 character set, the installer will refuse to continue with the datasource. This should be reverted to the behavior from 6.3 where it's possible to use this encoding for a new install.I can live with the somewhat nonsensical warning about unsupported character set / collation. 

            Currently, I would need to first install version 6.3, go through the Setup Assistant, then upgrade to 6.4. 

            {panel:bgColor=#e7f4fa}
            *INFO:* UTF8MB4 is now supported in confluence 7.3.1. Please see the notes to migrate from UTF8 to UTF8MB4 [here|https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html].
            {panel}             		New: As a confluence Administrator, when I set up a new instance of confluence 6.4 with MySQL using the utf8mb4 character set, the installer will refuse to continue with the datasource. This should be reverted to the behavior from 6.3 where it's possible to use this encoding for a new install.I can live with the somewhat nonsensical warning about unsupported character set / collation. 

            Currently, I would need to first install version 6.3, go through the Setup Assistant, then upgrade to 6.4. 

            {panel:bgColor=#e7f4fa}
            *INFO:* UTF8MB4 is now supported in confluence 7.3.1. Please see the notes to migrate from UTF8 to UTF8MB4 [here|https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html].
            Please follow !https://jira.atlassian.com/secure/viewavatar?size=xsmall&avatarId=51493&avatarType=issuetype! CONFSERVER-18509 - MySQL databases incapable of handling 4byte UTF-8 Characters. Confluence should handle this gracefully for instances still staying on UTF8 with MySQL and interested in seeing meaningful error when 4byte character is used in these instances.
            {panel}
            Ganesh Gautam made changes -
            Description Original: As a confluence Administrator, when I set up a new instance of confluence 6.4 with MySQL using the utf8mb4 character set, the installer will refuse to continue with the datasource. This should be reverted to the behavior from 6.3 where it's possible to use this encoding for a new install.I can live with the somewhat nonsensical warning about unsupported character set / collation. 

            Currently, I would need to first install version 6.3, go through the Setup Assistant, then upgrade to 6.4.              		New: As a confluence Administrator, when I set up a new instance of confluence 6.4 with MySQL using the utf8mb4 character set, the installer will refuse to continue with the datasource. This should be reverted to the behavior from 6.3 where it's possible to use this encoding for a new install.I can live with the somewhat nonsensical warning about unsupported character set / collation. 

            Currently, I would need to first install version 6.3, go through the Setup Assistant, then upgrade to 6.4. 

            {panel:bgColor=#e7f4fa}
            *INFO:* UTF8MB4 is now supported in confluence 7.3.1. Please see the notes to migrate from UTF8 to UTF8MB4 [here|https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html].
            {panel}
            Oliver Shen made changes -
            Resolution New: Done [ 17 ]
            Status Original: In Progress [ 3 ] New: Closed [ 6 ]
            Oliver Shen made changes -
            Fix Version/s New: 7.3.1 [ 91398 ]
            Fix Version/s Original: 7.3.0 [ 90890 ]
            Monique Khairuliana (Inactive) made changes -
            Fix Version/s New: 7.3.0 [ 90890 ]
            SET Analytics Bot made changes -
            UIS Original: 99 New: 100
            SET Analytics Bot made changes -
            UIS Original: 93 New: 99
            SET Analytics Bot made changes -
            UIS Original: 89 New: 93

              ggautam Ganesh Gautam
              a0addf24e7b1 Nils Meyer
              Votes:
              37 Vote for this issue
              Watchers:
              38 Start watching this issue

                Created:
                Updated:
                Resolved: