[wp-trac] [WordPress Trac] #18210: Update_post_meta is case insensitive on meta_key, but get_post_meta is NOT

[WordPress Trac]

#18210: Update_post_meta is case insensitive on meta_key, but get_post_meta is NOT
-------------------------------------------------+-------------------------
 Reporter:  anmari                               |       Owner:
     Type:  defect (bug)                         |      Status:  new
 Priority:  normal                               |   Milestone:  Awaiting
Component:  Database                             |  Review
 Severity:  normal                               |     Version:  3.2
 Keywords:  dev-feedback needs-patch needs-      |  Resolution:
  unit-tests                                     |     Focuses:
                                                 |  performance
-------------------------------------------------+-------------------------

Comment (by webaware):

 Replying to [comment:11 jrchamp]:
 > Rather than specifying the collation, you'll have better luck using the
 BINARY keyword.
 > ...
 > Note that it's also important from a performance perspective to place
 the BINARY keyword on the value side of the equals or regexp (otherwise,
 you may not be able to benefit from the existing index).

 Thanks for the tips, will try to remember for next time I bump into this
 one :)

--
Ticket URL: <https://core.trac.wordpress.org/ticket/18210#comment:12>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform