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

Details

    • Bug
    • Resolution: Handled by Support
    • Low
    • None
    • Unknown
    • None

    Description

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

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ankur.dhawan Ankur Dhawan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: