Problem changint encoding

[newspi]

Hi,

In the latest versión of Confluence, i change the encoding type to UTF-16. and save the configuration page.

In this moment, all don't work, i can't login, i can't change anything.

Is possible return to UTF-8 in any config file o table of the DB?

I use Confluence, self-hosted.

Thanks in advance

[newspi · Accepted solution]

Hi Shannon, i don't change te database encoding. I changhe un the main configuration page. In the edit box.

I need recreate the db for this change?

I think is a configuration file, i don't know.

Thsbks for the help.

[Shannon S]

Jordi,

You can try this:

1. Backup Confluence database
2. Stop Confluence
3. Run this query: 

   update bandana
   set bandanavalue = replace(bandanavalue, 'UTF-16', 'UTF-8')
   where bandanakey = 'atlassian.confluence.settings';

4. Start Confluence

Can you give that a try and let us know if you have any trouble?

Shannon

[newspi]

WoW, works greats!

Thanks Shannon!

[Shannon S]

Jordi,

You're welcome!

Take care.

Regards,

Shannon

[Shannon S]

Jordi,

Confluence encoding needs to be UTF-8.

You can change back in the database following this article:

• Configuring Database Encoding

If you have any trouble let us know your database version.

Thank you!

Shannon