SET - Setups
  1. SET - Setups
  2. SET-165

Provide alter script for MySQL and MS SQL Server documentation table to alter charset to allow unicode characters

    Details

    • Type: Fix Fix
    • Status: Released (View Workflow)
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 1.12.8
    • Fix Version/s: 1.12.9
    • Labels:
      None

      Description

      Current Situation

      • With the current documentation.sql script for MySQL to create the new documentation tables the columns NAME, DIRECTORY and PATH are created with CHARACTER SET latin1. This results in garbled entries for Text containing characters which are not in the latin1 character set.
      • With the current documentation.sql script for MS SQL Server to create the new documentation tables the columns NAME, DIRECTORY and PATH are created as VARCHAR. Additionally the hibernate configuration file for the reporting DB tables is configured with sendStringParametersAsUnicode=false; in the connection url property.

      Desired Behavior

      • For MySQL the columns have to be modified to allow unicode characters to be able to store text with characters which are not in the latin1 character set.
      • For MS SQL Server the columns have to be modified from VARCHAR to NVARCHAR to allow unicode characters to be stored.
      • For MS SQL Server the hibernate configuration file for the reporting DB tables has to be updated to remove the sendStringParametersAsUnicode=false; part in the connection url.

      Maintainer Note

      • For compatibility reasons, the setup does not remove the sendStringParametersAsUnicode=false; in the case of MSSQL.
      • This has to be removed manually, but the setup will not add the removed sendStringParametersAsUnicode=false; again during an update.

        Issue Links

          Activity

          There are no comments yet on this issue.

            People

            • Assignee:
              Santiago Aucejo Petzoldt
              Reporter:
              Santiago Aucejo Petzoldt
              Approver:
              Oliver Haufe
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: