cwrichardson

OK, thanks! That makes sense.

In that case, I’d like to add as a “nice to have” feature, the ability to add the note when manually adding guests. The use case is, you have people who for whatever reason don’t RSVP with the form (they send an email, a twitter direct message, or a physical card … all of which have happened for this event 🙂 ), and it would be nice to capture the message they actually send in one place when I manually add them.

Hmm. This didn’t seem likely, as the utf8mb4 upgrade came in WordPress 4.2, and this site is only about 5 months, but, just to double check, I

1. Put an emoji in a post comment (it worked fine)
2. Checked the character encoding for tables in the database

This was weird. The appropriate WordPress tables are utf8mb4:

mysql> SHOW FULL COLUMNS FROM wp_comments WHERE Field="comment_content";
| Field           | Type | Collation              |
| comment_content | text | utf8mb4_unicode_520_ci |

But, indeed, the RSVP plugin is set to regular utf8:

mysql> SHOW FULL COLUMNS FROM wp_attendees WHERE Field="note";
| Field | Type | Collation       |
| note  | text | utf8_unicode_ci |

So … I changed it:

mysql> ALTER TABLE wp_attendees MODIFY note text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

Woohoo! Problem solved!

So, thanks for the help, and all good at my end! But, why would it have created it that way in the first place?