The information on this page is included into other pages. When updating this page, add your content between the \{excerpt} tags if you want it to be included in other pages too.

'Collation' refers to a set of rules that determine how data is sorted and compared. Case sensitivity is one aspect of collation. Other aspects include sensitivity to kana (Japanese script) and to width (single- versus double-byte characters).

Case-sensitive or case-insensitive collation — how should you create your Confluence database? What about when you are migrating your existing Confluence instance from one database to another?

新しい Confluence インスタンスの設定

For new Confluence instances, we recommend using case-sensitive collation for your Confluence database. This is a default collation type used by many database systems. Confluence reduces all usernames into lower-case characters before they are stored in the Confluence database. This means that 'joebloggs', 'joeBloggs', 'JoeBloggs', etc. will be treated as the same username on a Confluence installation with case-sensitive database collation.

別のデータベースへの既存の Confluence インスタンスの移行

The default Confluence Standalone configuration uses case-sensitive database collation. This is typical of databases created under default conditions. If you are migrating from this type of configuration to a new database, we recommend that the new database uses case-sensitive collation. If you use case-insensitive collation, you may encounter data integrity problems after migration (for example, via an XML import) if data stored within your original Confluence site required case-sensitive distinctions.