Uploaded image for project: '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

    XMLWordPrintable

    Details

    • Type: Fix
    • Status: Released (View Workflow)
    • Priority: 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.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: