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 Oct 09, 2018 in Confluence

Introducing Praecipio Consulting, an Atlassian Solution Partner

Hey there Community!  My name is Vannya Vallejo, the Channel Communication Specialist at Atlassian and I want to help Atlassian users like you learn about our Solution Partners and how they c...

367 views 0 9
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