[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:
--------------------------+------------------------

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 (by SergeyBiryukov):

 Didn't mean to remove the emoji from description, not sure what happened
 here.

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