[wp-trac] [WordPress Trac] #34585: Updating via $wpdb->update fails when using Chinese Characters, depending on the characters postion in the string

[WordPress Trac]

#34585: Updating via $wpdb->update fails when using Chinese Characters, depending
on the characters postion in the string
--------------------------+------------------------------
 Reporter:  while1        |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  4.3.1
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by while1):

 Hi There,

 For the original Wordpress Tables:
 - utf8mb4_unicode_ci
 For our production tables, the ones wich are affected, i use
 - utf8_general_ci
 the wp-config.php setting is set to:
 - define('DB_CHARSET', 'utf8');
 The Website and Formulars are all set to
 - UTF8

 I didn't try to set the Encoding of our tables to utf8mb4_unicode_cim yet.
 Should i?
 We are handling '''ALL''' possible languages in our systems and already
 spent a lot of time internally into encoding compatibility issues but
 never needed to fix a thing on WP-Core side.

 I also saw your Video Annoucement some month ago when  you explained the
 WP-Core Update to UTF8mb4. And the reasons why you didi this. Let me say,
 In general i am '''very satisfied''' with the WP-Core database. Using it
 massively for the last 1.5 Years, never had any problems. The speed is
 quite good.

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