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 "?"

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

                Created:
                Updated:
                Resolved: