Skip to content

Set the 4 name fields to utf8mb4 #885

@hyanwong

Description

@hyanwong

In

call MakeFullUnicode('images_by_name', 'licence');
we set a number of search fields to utf8mb4. However, we also search in vernacular_by_name.name, vernacular_by_ott.name, ordered_nodes.name and ordered_leaves.name. Although these should only contain scientific ("latin") names, and so should not need full 4-byte unicode, it might be as well to add those columns to the list to MakeFullUnicode() too.

I assume that using utf8mb4 won't make searching these fields noticeably slower, but perhaps it's worth testing?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions