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..

          Form Name

            [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 added a comment -

            Hi,

            I have created a new support request for you at our support system https://support.atlassian.com and you can see the link above under the 'Issue Links' section. One of our engineers will be in touch with you soon.

            I am proceeding to close this issue.

            Cheers,
            Renjith

            RenjithA added a comment - Hi, I have created a new support request for you at our support system https://support.atlassian.com and you can see the link above under the 'Issue Links' section. One of our engineers will be in touch with you soon. I am proceeding to close this issue. Cheers, Renjith
            RenjithA made changes -
            Remote Link New: This issue links to "GHS-8861 (Atlassian Support System)" [ 46413 ]

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

                Created:
                Updated:
                Resolved: