german "Umlaut" cant get data from jira in confluence makro

[Marc Prüßmeier]

If we use the "JIRA Filter/Vorgänge" Makro and use there in the JQL Statement

german "Umlaut" like "ä ö ü" the JQL in the preview is working. On the main Page the makro then dont give data.

There seams to be a problem with UTF-8 Encoding somewhere:

JQL: Epic-Verkn\u00fcpfung = ENFOX-1   gives the right Values,

JQL: Epic-Verknüpfung = ENFOX-1           doesn't

in conf/server.xml there is everywhere set UTF-8

Is there a solution?

is postgre sql i have

Name      | Owner             | Encoding | Collate           | Ctype |
bitbucket | bitbucketuser | UTF8        | en_US.UTF-8 | en_US.UTF-8 |
confdb     | confluence     | UTF8        | C                    | C |
jiradb       | jira                  | UTF8        | C                    | C | 

[Suren Raj · Accepted solution]

Hi, Marc.

We can see you hit to a known bug, please refer to the below link:

• https://jira.atlassian.com/browse/CONF-43207

Please vote and watch the case so that your opinion on this issue may be heard by our development team, comments are also welcome. The bug will be addressed in accordance to our new bug policy.

There is a temporary workaround explained in the bug report. In order to apply it, you would need to modify your starting parameters to include the following and then restart confluence:

JAVA_OPTS="$JAVA_OPTS -Dfile.encoding=UTF-8"

[Marc Prüßmeier]

Thank you Suren,

I now set folowing:

in jira/bin/setenv.sh i added:

CATALINA_OPTS="-Dfile.encoding=UTF-8 -Dsun.jnu.encoding=UTF-8 ${CATALINA_OPTS}"

and in confluence/bin/setenv.sh i added too:

CATALINA_OPTS="-Dfile.encoding=UTF-8 -Dsun.jnu.encoding=UTF-8 ${CATALINA_OPTS}"

now it is working fine :-)

I thougt...

But now I have following in the editor:

if I open the Makro it looks correct:

In the Editor it looks like this:On the page it looks then correct:Other Makros in the Editor look like this: