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

JIRA is converting few chars to question mark "?"

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Handled by Support
    • Icon: Low Low (View bug fix roadmap)
    • None
    • Unknown
    • None

      We are using oracle database server on which encoding is set to: WE8ISO8859P1

      SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';
      NLS_CHARACTERSET WE8ISO8859P1

      Encoding on db cannot be changed to UTF-8 because same db is used for other applications that will get impacted because of this change.

      With default behavior of JIRA if i enter double quotes “ or ”, they get converted into question mark ?

      Since db is using this char set, we want to change JIRA to support same char set, to achieve this we have made change in following places:
      1. JIRA DB: using this query
      update propertystring set propertyvalue = 'ISO-8859-1' where id in (select id from propertyentry where property_key='webwork.i18n.encoding');

      2. JIRA start up file (setenv.sh), added following line in jvm arguments
      -Dfile.encoding=ISO-8859-1

      3. Tomcat's conf/server.xml added encoding
      URIEncoding="ISO-8859-1"

      After these changes and bouncing JIRA, i could see change reflected in my browser and could see encoding is chnaged from UTF-8 to ISSO-8859-1.. but the problem of quotes getting converted to question mark is still there..

      can you pls look into this and let me know what should be solution for this..

            [JSWSERVER-9523] JIRA is converting few chars to question mark "?"

            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2854145 ] New: JAC Bug Workflow v3 [ 2937443 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v7 - Restricted [ 2542864 ] New: JAC Bug Workflow v2 [ 2854145 ]
            Ignat (Inactive) made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - Restricted [ 1549512 ] New: JIRA Bug Workflow w Kanban v7 - Restricted [ 2542864 ]
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 909747 ] New: JIRA Bug Workflow w Kanban v6 - Restricted [ 1549512 ]
            Oswaldo Hernandez (Inactive) made changes -
            Workflow Original: GreenHopper Kanban Workflow 20141014 [ 743267 ] New: JIRA Bug Workflow w Kanban v6 [ 909747 ]
            Martin (Inactive) made changes -
            Issue Type Original: Support Request [ 5 ] New: Bug [ 1 ]
            mtokar.adm made changes -
            Workflow Original: GreenHopper Kanban Workflow v2 [ 543648 ] New: GreenHopper Kanban Workflow 20141014 [ 743267 ]
            RenjithA made changes -
            Resolution New: Handled by Support [ 8 ]
            Status Original: Open [ 1 ] New: Resolved [ 5 ]
            RenjithA made changes -
            Remote Link New: This issue links to "GHS-8861 (Atlassian Support System)" [ 46413 ]
            RenjithA made changes -
            Affects Version/s New: Unknown [ 31790 ]

              Unassigned Unassigned
              ankur.dhawan Ankur Dhawan
              Affected customers:
              0 This affects my team
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: