[wp-trac] [WordPress Trac] #43087: Unicode emoji in $wpdb->insert

[WordPress Trac]

#43087: Unicode emoji in $wpdb->insert
--------------------------+------------------------
 Reporter:  loranrendel   |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  Database      |     Version:  4.9.1
 Severity:  normal        |  Resolution:  duplicate
 Keywords:  close         |     Focuses:
--------------------------+------------------------
Changes (by SergeyBiryukov):

 * status:  new => closed
 * resolution:   => duplicate
 * component:  General => Database
 * milestone:  Awaiting Review =>


Old description:

> When trying using `$wpdb->insert` with if containing unicode emoji 😉,
> the method returns false and no inserts happens.
>
> It happens inside following core code in `_insert_replace_helper`:
> {{{
> $data = $this->process_fields( $table, $data, $format );
> if ( false === $data ) {
>         return false;
> }
> }}}

New description:

 When trying using `$wpdb->insert` with if containing unicode emoji , the
 method returns false and no inserts happens.

 It happens inside following core code in `_insert_replace_helper`:
 {{{
 $data = $this->process_fields( $table, $data, $format );
 if ( false === $data ) {
         return false;
 }
 }}}

--

Comment:

 Duplicate of #32315.

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