Search result is messy code in "Find a Confluence page" in JIRA

[Tom]

confluence 6.6,jira 7.6.1,mysql is set to utf8 . 

similar problem  link , hope it can be solved this time~~~

[Moga · Accepted solution]

Hi Tom,

MySQL collation is actually on 3 levels - database, table, and column. Please use How to Fix the Collation and Character Set of a MySQL Database to check if you have any mismatch over there.

Besides that, you should also check the encoding settings. You can use the steps in JIRA Application internationalisation and encoding troubleshooting to make sure you are using the correct encoding.

Please also check if this is happening on different browsers and machines - this will rule out any specific settings on your machine.

Cheers,
Moga

[Tom]

This question was perfectly resolved，thank you very much.

[Moga]

Hi Tom, happy to help! :)

[ttaoyuan]

hi, tom ,how you solved this ?  i have the same problem ,but followed the guide which Muthsamy offered still not working. tks 

[Tom Zhu]

From the Support ZIP, I can see this:

    <file.encoding>GBK</file.encoding>

Please perform the steps in JIRA Application internationalisation and encoding troubleshooting - Atlassian Documentation and let us know how it goes.

[ttaoyuan]

tks ,tom

i have created the support zip just now too,and found the same setting as you 

    <file.encoding>GBK</file.encoding>

but how to fix this? 

i did  the every steps  in  JIRA Application internationalisation and encoding troubleshooting - Atlassian Documentation  but still not working

[ttaoyuan]

and i guess this instruction is very linked  to my issue ,unfortunately ,not working .

Start JIRA with the variable -Dfile.encoding=utf-8 and -Dsun.jnu.encoding=UTF-8. See Setting properties and options on startup.https://confluence.atlassian.com/adminjiraserver070/setting-properties-and-options-on-startup-749383528.html

and my code in setenv.bat is:

JVM_SUPPORT_RECOMMENDED_ARGS= -Dfile.encoding=utf-8 and -Dsun.jnu.encoding=UTF-8

[ttaoyuan]

does anyone run into the same problem? hope atlassian can solve this entirely  

[Moga]

Hi Tao,

and my code in setenv.bat is:

JVM_SUPPORT_RECOMMENDED_ARGS= -Dfile.encoding=utf-8 and -Dsun.jnu.encoding=UTF-8

There should not be "and" in there. Please use the following line:

JVM_SUPPORT_RECOMMENDED_ARGS= -Dfile.encoding=utf-8 -Dsun.jnu.encoding=UTF-8

Plus if you are starting JIRA via Windows Service, then you should not be editing the setenv.sh file at all. It is stated in the documentation.

As mentioned in the documentation, can I know if you have verified that the changes actually is correct and took effect? You can refer to Verifying your settings.

Best Regards, 
Mogavenasan

[ttaoyuan]

thanks ，you are right， my windows should not edit in setenv.bat . it works !

[Moga]

You are welcome and glad to know that I can help you on this matter.