[wp-meta] [Making WordPress.org] #3295: Events API location search is case-sensitive

[Making WordPress.org]

#3295: Events API location search is case-sensitive
----------------------------+------------------
 Reporter:  SergeyBiryukov  |       Owner:
     Type:  defect          |      Status:  new
 Priority:  normal          |   Milestone:
Component:  API             |  Resolution:
 Keywords:  2nd-opinion     |
----------------------------+------------------

Comment (by Otto42):

 The NULL padding can be avoided by using these commands to do the
 conversion instead:

 {{{
 ALTER TABLE geoname_summary MODIFY name VARBINARY(200);
 ALTER TABLE geoname_summary MODIFY name VARCHAR(200) CHARACTER SET
 utf8mb4;
 }}}

 Using varbinary is the trick, and it seems to avoid the padding bytes.

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