Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-7838

Russian characters not stored correctly in SQL Server on GreenHopper

    XMLWordPrintable

Details

    • Bug
    • Resolution: Tracked Elsewhere
    • Medium
    • None
    • 6.1.3.2, 6.7.11
    • None

    Description

      When using SQL Server, unicode text (eg. Russian/Cyrillic) is not stored correctly in GreenHopper tables in the database. Characters are replaced with ?'s. The screenshot is on a vanilla instance with GreenHopper 6.1.3.2 installed. The issue seems to appears in Sprint (the name will change only after sprint started), Quickfilter, and Scrum.

      The following is the screenshot obtain from SQL Server database

      This issue seems to be similar to the bug reported in JRA-9154 on earlier version of JIRA. Where the issue relates to the field type where instead of VARCHAR is should be NVARCHAR

      Additional Info: This works correctly in Classic Board, but not Rapid Board.

      Attachments

        1. sql_collation.PNG
          sql_collation.PNG
          56 kB
        2. sql_collation1.png
          sql_collation1.png
          16 kB
        3. sql_collation2.jpg
          sql_collation2.jpg
          131 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              znoorsazali Zul NS [Atlassian]
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: