Problem/Motivation

After #1314214: MySQL driver does not support full UTF-8 (emojis, asian symbols, mathematical symbols) (Core), MySQL indexes cannot be longer than 191 characters. The Database backend db schema has an indexed field_name column with length 255. Indexes using a Database backend are not saved correctly, resulting in errors.

Proposed resolution

Lower the varchar length of indexed columns.

Remaining tasks

User interface changes

API changes

Data model changes

CommentFileSizeAuthor
#1 mysql-utf8-2510546-1.patch1.04 KBarla

Comments

arla’s picture

arla commented
Status: Active » Needs review
StatusFileSize
new mysql-utf8-2510546-1.patch1.04 KB
miro_dietiker’s picture

miro_dietiker
Location Switzerland
commented
Priority: Normal » Critical

This breaks Search API DB.

miro_dietiker’s picture

miro_dietiker
Location Switzerland
commented
Related issues: +#1314214: MySQL driver does not support full UTF-8 (emojis, asian symbols, mathematical symbols)
arla’s picture

arla commented

Did some local testing and it seems like all the current head fails are caused by this bug, and the provided patch solves them.

  • drunken monkey committed 4dcef7c on 8.x-1.x authored by Arla 
    Issue #2510546 by Arla: Fixed DB backend text field name column length.

Status: Needs review » Needs work

The last submitted patch, 1: mysql-utf8-2510546-1.patch, failed testing.

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented
Status: Needs work » Fixed

Ah, yes, of course. Thanks a lot for reporting, and already providing a patch!
The patch looks good, and since the test bot doesn't seem to be working, I've just committed this now.
Thanks again!

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.