[MDEV-27050] Utf8mb4 identifier is not working Created: 2021-11-15  Updated: 2023-11-01  Resolved: 2021-11-15

Status: Closed
Project: MariaDB Server
Component/s: Character Sets
Affects Version/s: 10.7.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Michael Assignee: Alexander Barkov
Resolution: Duplicate Votes: 0
Labels: None
Environment:

any, database/connection charset set to utf8mb4


 Description   

The following query is failing on MariaDB:

https://pastebin.com/chBUMTZK

on other DB vendors like Sqlite, MySQL 5.6.x, 8.x, PostgreSQL, MSSQL and even Oracle 11, it works well.

Currently, MariaDB emits an error:

General error: 1300 Invalid utf8mb4 character string: '\xF0\x9F\x9A\x80'

 Comments   
Comment by Sergei Golubchik [ 2021-11-15 ]

This is expected for now. The character_set_system is utf8mb3, so any characters that are outside of utf8mb3 repertoire (such as emoji) cannot be used in identifiers just yet.

This is being fixed. In MDEV-27009 (currently in progress) and MDEV-19123 (waits for the first one)

Comment by Michael [ 2023-11-01 ]

MDEV-27009 is fixed, what is the progress of this issue?

Generated at Thu Feb 08 09:49:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.