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:
...
Kodeblok |
---|
`BANDANAVALUE` mediumtext CHARACTER SET latin1, `BANDANAVALUE` longtext COLLATE utf8_bin, `VERSIONCOMMENT` mediumtext CHARACTER SET latin1, `VERSIONCOMMENT` longtext COLLATE utf8_bin, `BODY` mediumtext CHARACTER SET latin1, `BODY` longtext COLLATE utf8_bin, `KEYSPEC` text CHARACTER SET latin1 NOT NULL, `KEYSPEC` mediumtext COLLATE utf8_bin NOT NULL, `text_val` mediumtext CHARACTER SET latin1, `text_val` longtext COLLATE utf8_bin, `CONTENT` mediumtext CHARACTER SET latin1, `CONTENT` longtext COLLATE utf8_bin, `LICENSEKEY` text CHARACTER SET latin1, `LICENSEKEY` mediumtext COLLATE utf8_bin, |
The comcomplete 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.