[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:  needs-patch  |     Focuses:
-------------------------+------------------------------
Changes (by sajib1223):

 * keywords:  close => needs-patch


Comment:

 == Reproduction Report
 === Description
 This report validates whether the issue can be reproduced.

 === Environment
 - WordPress: 6.9
 - PHP: 8.3.29
 - Server: nginx/1.27.5
 - Database: mysqli (Server: 8.0.33 / Client: mysqlnd 8.3.29)
 - Browser: Firefox 147.0
 - OS: Windows 10/11
 - Theme: Astra 4.12.1
 - MU Plugins:
   * Object Cache Pro (MU) 1.19.0
 - Plugins:
   * Test Reports 1.2.1

 === Steps taken
 1. Went to Posts > tags.
 2. Created 2 tags with `ٱللَّهِ` & `ٱللَّهُ`.
 3. Performed a search with `ٱللَّهُ`.
 4. Both `ٱللَّهِ` & `ٱللَّهُ` term is shown in the result.
 5. ✅ Error condition occurs (reproduced).


 === Screenshots/Screencast with results

 Search result:
 [[Image(https://files.catbox.moe/s3gx40.png)]]

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