[wp-trac] [WordPress Trac] #32108: Cannot perform non-ascii selects when COLLATE is being used

[WordPress Trac]

#32108: Cannot perform non-ascii selects when COLLATE is being used
--------------------------+------------------------------
 Reporter:  willstedt     |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  4.1.2
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by willstedt):

 Just noticed that the reason for using COLLATE in the query was not for
 the sorting of the results, but to exclude false results. Searching for
 "aaaa" would return a hit when the text contains "åååå" even if the
 characters are different and should be treated differently. This doesn't
 change anything though, as the bug is still there, but maybe clarifies the
 use case a little bit.

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