MySQL JDBC URL suggestion for non-latin characters is incorrect

XMLWordPrintable

    • Type: Bug
    • Resolution: Timed out
    • Priority: Low
    • None
    • Affects Version/s: 6.4.1
    • None
    • 1
    • Severity 2 - Major

      Steps to replicate :

      1. Start Confluence setup wizard
      2. Input your Confluence license and click next
      3. Choose "My own database" and click next
      4. Select MySQL as Database type and click next
      5. Click on Direct JDBC
      6. Notice that the suggestion says to append &useUnicode=true&characterEncoding=utf8 if using non-latin characters.
      7. Append the following to add unicode support as mentioned on the page :
        &useUnicode=true&characterEncoding=utf8
      1. Input your database User Name and Password then click next

      Current Behavior : You will get the following error as per the screenshot below :

      Expected Behavior : The error is expected when the url is not structured correctly. If the url does not already contain a query string, it will fail as above.

      Workaround : If the url does not contain a query string already (beginning with ?), then you need to add the following, instead:

      ?useUnicode=true&characterEncoding=utf8

        1. mysqlError.jpg
          118 kB
          Der Lun

            Assignee:
            Unassigned
            Reporter:
            Der Lun (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: