Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

from jira link to confluence ,chinese show messy code Edited

1.png

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)

 

 

 

 

3 answers

1 accepted

0 votes
Answer accepted
Andy Heinzer Atlassian Team Apr 18, 2018

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.

thanks andrew

as the kb,the results itself looks fine :

1、

2.png

2、

3.png

Andy Heinzer Atlassian Team Apr 19, 2018

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:

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

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

 

thanks very much , this question confused me for days !

0 votes

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.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,375 views 22 32
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you