[MDEV-29414] Map utf8 OS locales to utf8mb4 Created: 2022-08-30  Updated: 2024-02-06

Status: Open
Project: MariaDB Server
Component/s: Character Sets
Fix Version/s: 11.5

Type: New Feature Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-30041 don't set utf8_is_utf8mb3 by default ... Open
Relates
relates to MDEV-19123 Change default charset from latin1 to... Open
relates to MDEV-28068 Change NATIONAL from utf8mb3 to utf8mb4 Open

 Description   

To help users to switch to utf8mb4 easier (see MDEV-19123), let's remap utf8 operating system locales (such as en_US.UTF-8 on Linux) from the current utf8mb3 to utf8mb4.

Another option is to take into account OLD_MODE, to map locales like en_US.UTF-8 to MariaDB character sets as follows:

  • to utf8mb3 if OLD_MODE=utf8_is_utf8mb3 is specified
  • to utf8mb4 otherwise
Generated at Thu Feb 08 10:08:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.