Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-7549

Automatic fix of DB columns with case-insensitive charset on MySQL and MSSQL

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.5
    • Component/s: Database
    • Labels:

      Description

      Having a case-sensitive charset has a been a strong requirement for a while. Otherwise it leads to many unexpected side-effects that are hard to investigate to impossible to fix.
      Unfortunately many MySQL and MSSQL databases have case-insensitive charset by default. As it's possible to fix charset on existing data, this must be done automatically by SQ during startup.

      Note that Oracle and Postgres do not support case-insensitive charsets, so no problem so far !

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              simon.brandhof Simon Brandhof (Inactive)
              Reporter:
              simon.brandhof Simon Brandhof (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: