legacy-knowledge-base
公開されました Sep. 10, 2025

アップグレード処理中のコレーションの不正な組み合わせ

written-by

Dávid Hegedüs

How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!

While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.

legacy-article

learn-legacy-article-disclaimer-text

問題

  • データベースの照合順序が Liferay が期待するものと異なる場合、特定のアップグ レードステップにおいて、次のようなエラーや類似のエラーが発生することがあり ます:
    com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:136) ~[portal-kernel.jar:?]
    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:157) ~[portal-kernel.jar:?]
    at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor$UpgradeInfosRunnable.run(UpgradeExecutor.java:230) ~[?:?]
    at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:134) [bundleFile:?]
    at com.liferay.portal.upgrade.internal.executor.SwappedLogExecutor.execute(SwappedLogExecutor.java:51) [bundleFile:?]
    at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.executeUpgradeInfos(UpgradeExecutor.java:158) ~[bundleFile:?]
    at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.execute(UpgradeExecutor.java:118) ~[bundleFile:?]
    ...

Environment

  • Liferay DXP 7.0+

解決策

  • portal-upgrade-database.properties のjdbc.default.urlプロパティにconnectionCollation=utf8_unicode_ciパラメータを追加する。
  • データベースでutf8_general_ci照合順序を使用していることを確認する。
  • 照合順序が正しくない既存のデータベースを変換することも可能です

追加情報

did-this-article-resolve-your-issue

legacy-knowledge-base