Problem

When defining a quickfilter name for Agile Boards, if the name is using Japanese or Russian characters, it will be shown as "???"

Diagnosis

Environment

• Only impacting users with Microsoft SQL Server Database

Diagnostic Steps

• Run the following SQL to verify what data type is used for the 

  SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'AO_60DB71_QUICKFILTER' AND COLUMN_NAME = 'NAME';

• Alternatively, you may check as below. Check on NAME and QUERY Column.
  
• If result return VARCHAR, proceed to workaround
  
  

Cause

• The bug is due to the data type for the columns, where the data type should be as NVARCHAR instead of VARCHAR

Workaround

Follow steps below

• BACKUP YOUR DATABASE
• STOP JIRA

• Run the following in your database

  ALTER TABLE dbo.AO_60DB71_QUICKFILTER
  ALTER COLUMN NAME NVARCHAR(255) NOT NULL
  GO
  ALTER TABLE dbo.AO_60DB71_QUICKFILTER
  ALTER COLUMN QUERY NVARCHAR(255)

• START JIRA
• RETEST

Resolution

• A bug have been raised for this and have been fixed in JIRA 7 and above