from jira link to confluence ,chinese show messy code

[ttaoyuan]

as the pic above shows :

from the jira 's issue link to confluence ,the results shows messy code. and even from confluence create jira question 's too.

i followed the instruction in this topic:https://community.atlassian.com/t5/Jira-Software-questions/Search-result-is-messy-code-in-quot-Find-a-Confluence-page-quot/qaq-p/691926  but not working well .can anyone can give me a hand? tks

the jira's version:7.9.0 on win x64 . sql server 2012 sp4 tomcat(built-in)

the confluence version:6.7.1 on winx64  sql server 2012 sp4 tomcat(built-in)

[Andy Heinzer · Accepted solution]

The related thread you posted can be helpful, but it does appear to pertain more to mysql database environments.  I understand you are using MS SQL instead, however the general concept is the same.  It is the technical details that could be different here.

Since we see this feed data is coming from Confluence, I think we should focus on the settings and configuration in Confluence itself first.  Please see the KB: Troubleshooting Character Encodings

I would recommend following this KB to start.   There are a number of locations to check for a problem like this, from the database setup itself, the database encoding, database collations, but then also the java settings that Confluence is using, and what character set is being used on the application level.

I would start with #1 from that KB:

1. Run the encoding test

Confluence includes an encoding test that can reveal problems with your configuration. You'll need to be a Confluence admin to do this. 

1. Head to <your-confluence-url>/admin/encodingtest.action 
2. Follow the prompts to paste a line of text and start the test.  You can also paste text in a specific language, for example Japanese, if you're experiencing a particular problem with that language.  

I would be interested to see what results you get back from that test first.   Perhaps a screenshot would be helpful here for us to also understand what next steps to take from there.

[ttaoyuan]

thanks andrew

as the kb，the results itself looks fine ：

1、

2、

[Andy Heinzer]

If you are only seeing this problem when viewing the data through Jira, and you never seen this kind of problem when only in Confluence, then perhaps I was mistaken and the problem could in fact lie with Jira instead.

To test this out, I would recommend trying to follow the steps in JIRA Application internationalisation and encoding troubleshooting.  Specifically from that article there are steps you can take to make sure that the application is using the UTF-8 encoding:

• Start JIRA with the variable -Dfile.encoding=utf-8 and -Dsun.jnu.encoding=UTF-8. See Setting properties and options on startup.

If your Jira instance is using a different character encoding, such as ANSI, cp1252 (commonly found for Jira instances on Windows platforms), then these other character encodings do not always have the ability to show all the correct characters, especially in language sets such as Chinese, Japanese, and Korean.   In which case it might explain why you see a ? character instead sometimes.   I would recommend trying to set those two JVM arguments as described in that link and then restarting Jira to have these settings changes take effect.

Please let us know the results.

Andy

[ttaoyuan]

Great ,it solved ,andrew thank you very much ,it's  very kind of you.

the key is :

Start JIRA with the variable -Dfile.encoding=utf-8 and -Dsun.jnu.encoding=UTF-8. See Setting properties and options on startup.

and why did not work before? becos it's my mistake , i added the parameter to setenv.bat . but the default installation of jira on windows should be "as service" .

[Ollie Guan]

Hello @ttaoyuan ,

Join your city’s online group to keep the conversation flowing.

https://ace.atlassian.com/shanghai/

https://ace.atlassian.com/beijing/

https://ace.atlassian.com/hang-zhou/

https://ace.atlassian.com/shen-zhen/

https://ace.atlassian.com/guang-zhou/

Feel free to add my Wechat（guanqun1982） and join ACE in China.

[yangjiae]

thanks very much , this question confused me for days !