MySQL データベースの照合と文字セットを修正する方法
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
In newer versions of Confluence, database requirements become more and more stringent. This is to ensure that users get the most consistent experiences when working with content, regardless of the content in their database.
MySQL では、次のレベルで異なる照合セットがあるため、照合が複雑になる場合があります。
- データベース レベル
- テーブル レベル
- カラム レベル
Additionally, information inside a column may be encoded incorrectly as well - causing the data in that column to be displayed incorrectly.
If your MySQL database doesn't use the recommended collation and character sets, you can run these queries against your database to bring them into line with the Recommended Database Setup For MySQL.
Before Proceeding
Before proceeding, ensure that you:
- Confluence をシャットダウンします。
- Complete a full database backup
You may also wish to apply these changes in a test environment before applying them to production.
目次
- MySQL Collation Repair: Database Level Changes
- MySQL Collation Repair: Table Level Changes
- MySQL Collation Repair: Column Level Changes
- MySQL Collation Repair: Column Level Encoding Issues
- MySQL Collation Repair: Case Study - Repairing a Production Database