Bug 1306731 - RFE: Add MySQL 5.7 for supporting 4 byte characters in MySQL connections by default
Summary: RFE: Add MySQL 5.7 for supporting 4 byte characters in MySQL connections by d...
Keywords:
Status: CLOSED DUPLICATE of bug 1353985
Alias: None
Product: Red Hat Software Collections
Classification: Red Hat
Component: mysql
Version: rh-mysql57
Hardware: All
OS: Linux
unspecified
medium
Target Milestone: alpha
: 2.2
Assignee: Jakub Dorňák
QA Contact: qe-baseos-daemons
URL:
Whiteboard:
Depends On: 1353985
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-02-11 16:43 UTC by Bryan Totty
Modified: 2019-12-16 05:23 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-08-08 13:28:08 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Bryan Totty 2016-02-11 16:43:40 UTC
Description of problem:

Refer to the Atlassian bug report JRA-36135 (https://jira.atlassian.com/browse/JRA-36135). Even though MySQL 5.5 and MySQL 5.6 support 4-byte UTF-8 via utf8mb4 charset, the MySQL InnoDB engine limitations (767 bytes is a maximum for a indexed field) hinder its usefulness. These limitations are rectified in MySQL 5.7, which can be configured to support larger indexable fields than 767 bytes.

Due to prior versions of MySQL not correctly supporting 4-byte UTF-8 characters, MySQL 5.5 and MySQL 5.6 cannot be used as a database backend for e.g. Atlassian JIRA without running into issues that relate to 4-byte UTF-8 characters being present in user input. Usually this means that the application cannot commit data to the database when the input contains 4-byte UTF-8 characters.

There is a related Openshift BZ:

https://bugzilla.redhat.com/show_bug.cgi?id=1186681

Version-Release number of selected component (if applicable):
Software Collections:
rh-mysql56-mysql-5.6.26-1.el6

Additional info:
Other Reference-
https://www.drupal.org/node/1314214


Note You need to log in before you can comment on or make changes to this bug.