[wp-meta] [Making WordPress.org] #386: Trac truncates data at 4-byte UTF-8 characters

[Making WordPress.org]

#386: Trac truncates data at 4-byte UTF-8 characters
-----------------------------+--------------------
  Reporter:  SergeyBiryukov  |      Owner:
      Type:  defect          |     Status:  closed
  Priority:  normal          |  Component:  Trac
Resolution:  fixed           |   Keywords:
-----------------------------+--------------------
Changes (by nacin):

 * status:  new => closed
 * resolution:   => fixed


Comment:

 I've fixed this for core.trac by converting most utf8 columns to utf8mb4.
 Other Tracs including meta.trac, which all still use SQLite, were
 unaffected.

 I say most because primary key index lengths (`innodb_large_prefix` is not
 on) blocked it on the attachment, component, milestone, node_change,
 ticket_custom, and wiki tables. None of these fields have a pressing (or
 any) need for four-byte characters in them.

--
Ticket URL: <https://meta.trac.wordpress.org/ticket/386#comment:4>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org