8000 Convert all field from utf8 to utf8mb4 · Issue #1054 · unacms/UNA · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
Convert all field from utf8 to utf8mb4 #1054
Closed
@AlexTr

Description

@AlexTr

We need to do it to support native emoji, now when native emoji is entered part of content is lost(after emoji symbol) and may cause some PHP errors

For Db:

ALTER DATABASE db_name_here CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

For each table:

ALTER TABLE table_name_here CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

For each field (change type accordingly):

ALTER TABLE table_name_here CHANGE field_name_here field_name_here field_type_here(X) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  • Change upgrade/classes/BxDolUpgradeDb.php file, after update is applied
  • Apply conversion to Jot Messenger with next update

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      0