[wp-trac] [WordPress Trac] #44386: Problem with utf8mb4_unicode_ci collation for arabic content

[WordPress Trac]

#44386: Problem with utf8mb4_unicode_ci collation for arabic content
-------------------------+------------------------------
 Reporter:  array064     |       Owner:  (none)
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  Database     |     Version:  4.9.6
 Severity:  major        |  Resolution:
 Keywords:  close        |     Focuses:
-------------------------+------------------------------
Changes (by r1k0):

 * keywords:  needs-testing => close


Comment:

 == Reproduction Report

 === Environment
 - WordPress: 6.9
 - PHP: 8.4.17
 - Server: PHP.wasm
 - Database: WP_SQLite_Driver (Server: 8.0.38 / Client: 3.51.0)
 - Browser: Chrome 144.0.0.0
 - OS: Windows 10/11
 - Theme: Twenty Twenty-Five 1.4
 - MU Plugins: None activated
 - Plugins:
   * Test Reports 1.2.1

 === Steps taken
 1. Head over to **Posts > Tags**.
 2. Add these two tags provided by the reporter above.
 3. Use the first tag provided by the reporter to search for a tag.
 4. ❌ Bug is not occurring

 === Expected behavior
 - Only one result is shown for that search term, matching the search term.

 === Additional Notes
 - I was not able to reproduce the behavior where both terms appear.
 - This issue may no longer be reproducible on current WordPress/MySQL
 versions.
 - I will be marking this as `close` unless further reports confirm
 otherwise

 === Screencast with results
 https://files.catbox.moe/q0lfws.webm

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