Japanese and Russian Characters not showing when defining quickfilters
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
問題
When defining a quickfilter name for Agile Boards, if the name is using Japanese or Russian characters, it will be shown as "???"
診断
環境
- 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
原因
- The bug is due to the data type for the columns, where the data type should be as NVARCHAR instead of VARCHAR
回避策
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
ソリューション
- A bug have been raised for this and have been fixed in JIRA 7 and above
最終更新日: 2016 年 2 月 26 日
Powered by Confluence and Scroll Viewport.