Simplified Chinese Resorts to Question Marks


Server version of Confluence: 5.5.3 on a Linux CentOS box.

I have a page with Chinese vocabulary, and four colums, the second of which is simplified Chinese.  As my client is a Mac, I can enter the text in Pinyin and get the Chinese character.  I then save the page, and all is well until about ten minutes later, when I view the page, and the Chinese character has reverted to a question mark.

This is double curious because when I first insert the character there, I can view the page on any number of browsers, and the character is Chinese. 

I ran the character encoding text and it came back successful. 

Is there something else I need to do?


3 answers

Hey John,

I believe I know what is going on, if you are using MS SQL Server then try the following:

  1. Shutdown Confluence.
  2. On MSSQL Studio go to Tools > Options> Designer > Table and Database Designers > Uncheck the box Prevent saving changes that require table re-creation.
  3. Expand Body Content table.
  4. Expand Columns.
  5. Right click on BODY column.
  6. Modify.
  7. Change the BODY column from text to ntext.
  8. Save.
  9. Start Confluence.
  10. Test the same scenario again.

That behaviour happens on MSSQL when you have a incorrect data type since the jdts driver have problems to handle asiatic characters. 

If you are not using MSSQL then if you have a support license can you raise a support case with us at so we can get your supportzip?

Thanks and Regards,
David|Confluence Support Engineer
0 votes
Wayne Wong Atlassian Team Oct 19, 2014

Hi John, Could you please attach the test result here so that we could verify the test for you? Also, is that possible for you to generate a support zip?The support contains your system environment info, It will help us to identify the issue faster if you could provide us support zip, Thank you. Regards, Wayne Wong

Hi Wayne,

That's not a problem, except that it has my entire configuration in it, and I don't really want that on a google-visible page.  Any way I can send it to you as an e-mail?    As fo the test results, screenshot attached.  Capture d’écran 2014-10-20 à 10.11.00.png

Cheers.  smile

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Dec 18, 2018 in Confluence Cloud

Happy holidays from our team to yours!

Hi Community!  2018 was filled with changes for our team, both big and small, and we've taken a lot of time to both celebrate our wins and recognize areas of improvement. One thing that we're a...

462 views 3 18
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you