Home  >  Q&A  >  body text

php - mysql encoding format modification?

The problem is this: the encoding of an online table is utf8; but now it needs to be changed to utf8mb4. If the table data is not backed up and the table's encoding and corresponding field encoding are directly modified to utf8mb4, will it affect the data?

为情所困为情所困2689 days ago939

reply all(4)I'll reply

  • 高洛峰

    高洛峰2017-07-01 09:14:00

    The difference between utf8mb4 and utf8
    The set of utf8mb4 is larger than the set of utf8

    utf8mb4 is compatible with utf8 and can represent more characters than utf8.

    If you expand from a small subset to a larger set, it will have no impact on the original data

    reply
    0
  • 为情所困

    为情所困2017-07-01 09:14:00

    utf8mb4 is a superset of utf8

    reply
    0
  • 迷茫

    迷茫2017-07-01 09:14:00

    Yes, utf8mb4 is a superset of utf8

    reply
    0
  • 女神的闺蜜爱上我

    女神的闺蜜爱上我2017-07-01 09:14:00

    Do you want to save emoji? It can be changed without affecting the original data

    reply
    0
  • Cancelreply