Hi
I have installed confluence on my server, but I can's create pages with Armenian text. I mean, I can create pages, but see text as ???, how we can fix it?
Hi Rafik,
I assume you're referring to the page itself and not a PDF export of the page, correct?
To troubleshoot your encoding issue, please have a look at Troubleshooting Character Encodings.
You will also need to be sure that your database is using the required encoding we have specified, and the article will show you how to do that in Configuring Database Encoding.
I hope this helps!
Kind regards,
Shannon
Thanks for answer, I tried as in documentation.
Test say me this:
In terminal about character sets have this:
But in confluence, as you can see, in textarea I have what I was enter, but in page I have ??
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rafik,
I have a few tasks for you to check, which will ensure that all encoding and collation is correct. Please follow closely and let us know if you have any trouble.
Task 1:
<sun.jnu.encoding>UTF-8</sun.jnu.encoding
<file.encoding>UTF-8</file.encoding>
CATALINA_OPTS="$CATALINA_OPTS -Dfile.encoding=UTF-8”
CATALINA_OPTS="$CATALINA_OPTS -Dsun.jnu.encoding=UTF-8"
Task 2:
jdbc:mysql://localhost/confluence?sessionVariables=storage_engine%3DInnoDB&amp;useUnicode=true&amp;characterEncoding=utf8
Task 3:
Task 4:
Please let me know the results of these tests and if you have any trouble!
Shannon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, thanks for answering
I was checked and resolved all cases, that you have sent, want to say step by step whats changed:
Task 1 → 1, 2(sun.jnu.encoding, file.encoding) Provide me those lines, using this example:
It’s not UTF 8, so I was go to Task 1 → 6, do what you have writed and do restart confluence.
Task 2 → 2 Look for your database details, which should look similar to this:
I have only "jdbc:mysql://localhost/confluence", so I’m added get parameters myself: sessionVariables=storage_engine%3DInnoDB&amp;useUnicode=true&amp;characterEncoding=utf8 and restarted confluence
Task 3 → 1 SHOW VARIABLES LIKE 'collation%';
Task 4 → server.xml
As result nothing changed, I have not valid views in confluence, have any ideas what I can do else?
Regards and much thanks for help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rafik,
Your task #2 screenshot appears to not be the correct one for the query I asked you to run. I can see there you ran SHOW VARIABLES LIKE 'character_set%'; but actually I need you to run:
SHOW VARIABLES LIKE 'collation%';
Can you try that again and send me the results of your query?
One more thing you can do to check where the issue lies:
Shannon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.