Sidehistorik
...
This script will massconvert all tables to UTF-8 (needed from Confluence 5.3 2 and onwards):
| Status | ||||
|---|---|---|---|---|
|
...
The script originates from https://confluence.atlassian.com/display/CONFKB/Change+MySQL+Database+Character+Encoding+to+UTF8+During+Server+Migration - Thanx to Dejan Golja
A sample run
from a Confluence 5.2 installation:
...
The complete diff: diff.sql
Dont worry
This is a diff from a 5.2.5 instance - confluence5.2.5-dump.sql - And it has the same column types as after the script.