Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Support MySQL 8 database collations

Components

Labels

Description

  1. add support for "utf8mb3_general_ci" database collation on the "Database Configuration" and "Update Database Configuration" installation steps

  2. validate, that the chosen database collation exists in the used MySQL server version

Context Information

When installing In-Portal on MySQL 8 Server using "utf8_general_ci" collation (stored in the $_CONFIG['Database']['DBCollation'] key of the "/system/config.php" file), the charset (stored in the $_CONFIG['Database']['DBCharset'] key of the "/system/config.php" file) wasn’t populated (it should have been "utf8").

As a result, MySQL Server default collation/charset was used. Depending on the MySQL Server configuration that could have resulted in the incorrectly encoded data being stored in the database.

Additional information (do not use)

None

Activity

Show:

[API] Administrator November 17, 2024 at 4:41 PM

User (SVN User: "alex") committed a fix to 5.2.x. Commit Message:

Fixes https://in-portal.atlassian.net/browse/INP-1873#icft=INP-1873 - Support MySQL 8 database collations

Differential Revision: https://qa.in-portal.org/D481

Fixed

Details

Priority

Assignee

Reporter

Developer

Reviewer

Change Log Group

Fixed

Change Log Message

Patch Instructions

Patches must be submitted through Phabricator.

Time tracking

1h 30m logged

Story Points

Fix versions

Created August 5, 2024 at 12:32 PM
Updated December 29, 2024 at 8:46 PM
Resolved November 17, 2024 at 4:41 PM